Translate this line please

[#1]

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!

[sunny_talwar · Accepted solution]

This just means that only show those Status_Category where Status is not equal to Closed.

[#3]

Thank you!

[#4]

so if i wanted Status to exclude the field "Closed: Approved" would I change it to,

=if(Status <> 'Closed', 'Closed: Approved', Status_Category)?

[sunny_talwar]

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)