Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
JordiL
Contributor
Contributor

How to show values with a set analysis without doing calc

I've this problem. 

 

I want to show a list where the values where the values fulfilling this condition

{<[STATUS] = {'WMATL','WPCOND','WPLAN','WSCH','APPR','INPRG','ESPINF','WAPPR'}>}

 

But in this table I'm not doin any count. Just showing dimensiones. My question is how to use a set analysis or limit the values for this table so thsi table just show me these values.

Labels (2)
2 Replies
marcus_sommer

You may use it within any aggregation replacing a dimension with a measure or showing an extra information like a count or a rate. Beside this you may include it within a calculated dimension, for example with:

aggr(only({< ... >} Field), Field)

- Marcus

MarcoWedel

one solution using a hidden expression column:

MarcoWedel_0-1660857890430.png

MarcoWedel_1-1660857938087.png

 

MarcoWedel_2-1660857954220.png

 

MarcoWedel_3-1660857990326.png

 

hope this helps

Marco