Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

Filter Selection

Hi Experts,

I have two Filters,

1) Product

2) Price Segment.

Based on the Product filter value selection,  Price Segment Filter values should be visible.  Below is the mapping for your reference. 

Purushothaman_0-1657260122265.png

Anyone, Please help!!

Thank you!!

1 Solution

Accepted Solutions
justISO
Specialist
Specialist

Hi, you can try to edit 'Price Segment' filters field to:

 

=IF(GetFieldSelections(PRODUCT)='TV', IF(WildMatch([PRICE SEGMENT],'*TV*','*ALL*'), [PRICE SEGMENT]),
IF(GetFieldSelections(PRODUCT)='FAN', IF(WildMatch([PRICE SEGMENT],'*FAN*','*ALL*'), [PRICE SEGMENT]),
IF(GetFieldSelections(PRODUCT)='GRINDER', IF(WildMatch([PRICE SEGMENT],'*GRINDER*','*ALL*'), [PRICE SEGMENT]),
[PRICE SEGMENT])))

 

View solution in original post

1 Reply
justISO
Specialist
Specialist

Hi, you can try to edit 'Price Segment' filters field to:

 

=IF(GetFieldSelections(PRODUCT)='TV', IF(WildMatch([PRICE SEGMENT],'*TV*','*ALL*'), [PRICE SEGMENT]),
IF(GetFieldSelections(PRODUCT)='FAN', IF(WildMatch([PRICE SEGMENT],'*FAN*','*ALL*'), [PRICE SEGMENT]),
IF(GetFieldSelections(PRODUCT)='GRINDER', IF(WildMatch([PRICE SEGMENT],'*GRINDER*','*ALL*'), [PRICE SEGMENT]),
[PRICE SEGMENT])))