Discussion board where members can get started with Qlik Sense.
is it possible to have this expression in master item dimension? it is giving me "invalid dimension error".
I've tried to put it in the master item - measure and it worked well... But I wanted it to be a dimension so I can have yes and no filter in the visualisation.
Go to Solution.
You would need to use Aggr() function around this to make it work
Aggr(If(Sum([Aggr nOffered]) > 1, 'yes', 'no'), Dimension)
or use it without Sum() if it is already aggregated
If([Aggr nOffered] > 1, 'yes', 'no')
Aggr(If(Sum([Aggr nOffered]) > 1, 'yes', 'no'), Dimension) - it worked!!