Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Anyone familiar with Qlik Sense? Working on a what should be a fairly simple project, mainly just was hoping to know why the way i'm filtering some charts continually is returning invalid dimension from the expression I'm using.
One example:
Trying to retrieve the name of certain parts of production but only if the rows don't indicate that there was a stop in the production. Again, using this as a dimension but returns invalid dimension. Wondering if it's the expression itself that is incorrect or if it's more based on the data/how I'm using it.
If(Program <> 'DETECT STOP', Program)
Thanks
Try this:
Aggr( Only({<Program=-{'DETECT STOP'}>}Program), Program)