Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm new to qlik and programming in general, I'm working on a dashboard that has previously been created by someone else. I need help understanding what this dimension means in order to continue with the changes i need to make to my chart
the dimension is:
=if(Status <> 'Closed', Status_Category)
Thanks in advance for your help!
This just means that only show those Status_Category where Status is not equal to Closed.
This just means that only show those Status_Category where Status is not equal to Closed.
Thank you!
so if i wanted Status to exclude the field "Closed: Approved" would I change it to,
=if(Status <> 'Closed', 'Closed: Approved', Status_Category)?
You can do it in few different ways
If(Match(Status, 'Closed', 'Closed: Approved') = 0, Status_Category)
or
If(not Match(Status, 'Closed', 'Closed: Approved'), Status_Category)
or
If(Status <> 'Closed' or Status <> 'Closed: Approved', Status_Category)
or
If(not WildMatch(Status, 'Closed*'), Status_Category)