topic Re: If statement questions in QlikView

If statement questions

Fri, 17 Jan 2014 16:27:30 GMT

Hi QlikView Peers,

I need help with following statement. I was able to change "Legal" to "Global Functions - Other" but somehow the script isn't able to include "Compliance & Control" to "Global Functions - Other". Please help.

IF([Primary Sector Impacted_1]='CC-Staff' and [Primary Business Impacted]='Legal' OR 'Compliance & Control', 'Global Functions - Other')

Thanks,

Jasmine

Re: If statement questions

Anonymous — Fri, 17 Jan 2014 16:31:29 GMT

Please try:

IF([Primary Sector Impacted_1]='CC-Staff' and [Primary Business Impacted]='Legal' OR [Primary Business Impacted]= 'Compliance & Control', 'Global Functions - Other')

thanks

Yaniv

Re: If statement questions

jerem1234 — Fri, 17 Jan 2014 16:31:51 GMT

You cant use the OR like you are using it, you would have to specify [Primary Business Impacted] = 'Compliance & Control' again.

Try this if statement:

IF([Primary Sector Impacted_1]='CC-Staff' and ([Primary Business Impacted]='Legal' OR [Primary Business Impacted] = 'Compliance & Control'), 'Global Functions - Other')

or you could use the match function:

IF([Primary Sector Impacted_1]='CC-Staff' and match([Primary Business Impacted], 'Legal', 'Compliance & Control'), 'Global Functions - Other')

Hope this helps!

Re: If statement questions

Anonymous — Fri, 17 Jan 2014 16:32:23 GMT

IF([Primary Sector Impacted_1]='CC-Staff' and match([Primary Business Impacted],'Legal', 'Compliance & Control'), 'Global Functions - Other')

Re: If statement questions

Fri, 17 Jan 2014 16:37:35 GMT

Thank you for your quick responses.