Qlik Sense

[ukhanjemb]

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

[RafaelBarrios]

hi @ukhanjemb 

i dont see the a problem in that formula for using it as dimension.
can you paste a screenshot of the model and the place you are using it.

Check if the field has whitespaces in the begining or the end, and if it is correct it should show the same color as mine, and indicate 'OK' below