topic Re: Customized flags and expression in QlikView

Customized flags and expression

ilanbaruch — Sat, 16 Nov 2024 05:02:26 GMT

hi all,

in my model i have a pivot table with Product_id and month as a dimension,

sum(flag) - as an expression

result is as below :

i want to create a flag - for filtering or to use within an expression or or a calculated dimension

and the result will show only the id's with 1 value in the pivot table -

sum(flag)=1 in all months selected.

id's -126, 129 in the above table

any ideas?

advanced thanks

marcus_sommer — Thu, 06 Dec 2018 16:46:23 GMT

Maybe as a calculated dimension within a listbox:

if(aggr(count(distinct month) = sum(flag), id), 'all flags are 1', 'flags are missing')

- Marcus

ilanbaruch — Thu, 06 Dec 2018 22:06:17 GMT

Thank You Marcus. it works!
my final
=if(aggr(count(distinct month) = sum(ShowFlag), id), id)