Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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