Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
kisangoli78
Contributor
Contributor

Qlik Sense

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.

Labels (1)
1 Reply
lironbaram
Partner
Partner

hi , this function works only if each Program has one value 
you can use this expression in the dimension , 
aggr( if(Program<>'DETECT STOP',Program),LineID)