Qlik Sense

zabuza88 — Sun, 06 Mar 2022 15:16:48 GMT

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)

Re: Qlik Sense

Or — Mon, 07 Mar 2022 10:24:51 GMT

Try it the other way around:

=if(Program='DETECT STOP',null(),Program)

Load * INLINE [
Program, Value
DETECT STOP, 1
DETECT STOP, 2
Hello, 3
World, 4
Foo, 5
Bar, 6
];

topic Re: Qlik Sense in Reporting Service & Alerting

Qlik Sense

Re: Qlik Sense