Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
bravegril36
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

1 Reply
Chanty4u
MVP
MVP

try this

=If(Not wildmatch(Program ,'DETECT STOP'), Program)