Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eustisab
New Contributor III

invalid dimension

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.

invalid dimension.JPG

1 Solution

Accepted Solutions

Re: invalid dimension

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')

2 Replies

Re: invalid dimension

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')

eustisab
New Contributor III

Re: invalid dimension

Aggr(If(Sum([Aggr nOffered]) > 1, 'yes', 'no'), Dimension) - it worked!!



Thanks genius!

Community Browser