Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Enable selections\filtering on a field that is used in set analysis

Hi All,

I have a requirement to be able to filter a straight table even though the field is being used in set analysis.

IE

PRODUCTS are:

CHEESE SPREAD

JAM

MARGERINE

PEANUT BUTTER

I am displaying all products in a straight table that contain the letter "e" in set analysis with this expression:

sum({<PRODUCT={'*E*'}>}SALE_PRICE)

How can i change the above exp to allow me to be able to select CHEESE SPREAD for instance, from a listbox and the straight table should filter for this product only?

I.e

the straight table in the blue area should filter like how the table on left filters ...

Q1_set_Analysis_Filtered.PNG

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum({<PRODUCT *= {'*E*'}>}QTY)

View solution in original post

3 Replies
sunny_talwar

Try this:

Sum({<PRODUCT *= {'*E*'}>}QTY)

sunny_talwar

Learn about the operators here:

Implicit Set Operators

Anonymous
Not applicable
Author

Thanks Sunny!!