Discussion Board for collaboration related to Creating Analytics for QlikView.
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
Go to Solution.
Maybe as a calculated dimension within a listbox:
if(aggr(count(distinct month) = sum(flag), id), 'all flags are 1', 'flags are missing')