Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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