topic Re: Translate this line please in QlikView

Translate this line please

Thu, 19 Jan 2017 18:57:19 GMT

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!

Re: Translate this line please

sunny_talwar — Thu, 19 Jan 2017 19:10:25 GMT

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

Re: Translate this line please

Thu, 19 Jan 2017 20:12:41 GMT

Thank you!

Re: Translate this line please

Thu, 19 Jan 2017 20:15:52 GMT

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

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

Re: Translate this line please

sunny_talwar — Thu, 19 Jan 2017 20:18:59 GMT

You can do it in few different ways

If(Match(Status, 'Closed', 'Closed: Approved') = 0, Status_Category)

If(not Match(Status, 'Closed', 'Closed: Approved'), Status_Category)

If(Status <> 'Closed' or Status <> 'Closed: Approved', Status_Category)

If(not WildMatch(Status, 'Closed*'), Status_Category)