topic Re: How to show values with a set analysis without doing calc in QlikView

How to show values with a set analysis without doing calc

JordiL — Wed, 17 Aug 2022 14:12:59 GMT

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.

Re: How to show values with a set analysis without doing calc

marcus_sommer — Wed, 17 Aug 2022 15:43:33 GMT

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

Re: How to show values with a set analysis without doing calc

MarcoWedel — Thu, 18 Aug 2022 21:27:21 GMT

one solution using a hidden expression column:

hope this helps

Marco