How to apply filter

#1

How to apply multiple filters on the product list?

0 Likes

#2

Hi, could you please help us in providing more details about your requirement? What filters are required? Where are you storing data to be fetched in these filters, etc.?

0 Likes

#3

I have a SKU List page wherein SKUs are listed based on Super Category & Brand (were selected on previous pages). On I want to slice and deice my SKU List based on the Category->Segment and Sub-Segment.

Please note - All these parameters are in single sheet.

Let me know in case of more details. Happy to share.

0 Likes

#4

In this case, you can use multiple filters in LOOKUP() function. For instance, if you want to search a SKUs based on Super Category, Brand and Category/Segment/Sub-Segment, then you can use AND() in LOOKUP() as shown below -

LOOKUP([SKUs.unique_id],AND(SKUs.supercategory=supercategorycontrol, SKUs.brand=brandscontrol,SKUs.category=categorycontrol,SKUs.segment=segmentcontrol,SKUs.subsegment=subgmentcontrol))

Where, supercategorycontrol/brandscontrol/categorycontrol/segmentcontrol/subgmentcontrol are respective controls to select values for Super Category/Brands/Category and so on.

0 Likes