topic Re: What's wrong with my if syntax? :( in QlikView

What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:22:10 GMT

Hi,

I have a table of account information (from Salesforce) in QV. Each account has an Account ID and Account Status (Customer, Lost Customer, Work in Progress, etc).

I wanted to create an expression that would return 1 if an account was in Customer status and 0 else. This is the expression I used:

if(([Account Status]='Customer'),1,0)

for some reason, when I create a straight table with Account ID as dimension and the expression above as the expression, QV would only show the Accounts with 1 (i.e. the customers), and not all the others. This persists of course after hitting clear.

What am I doing wrong?

Thanks!

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:25:04 GMT

Hi Al,

may be you can check what QV does about missing or zero values. (hidding ?)

best regards

Chris

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:27:33 GMT

Try this:
If([Account Status]='Customer',1,0)

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:34:48 GMT

Go to Presentation tab in the stright table -> Uncheck Suppress zero values and click Ok, You would see the results correctly.

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:43:09 GMT

so basic, so simple, how embarassing thanks a lot!

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:44:21 GMT

Hi,

Try to add another expression like "Only({1} [Account ID])" and hide this column from Presentation tab.

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:44:25 GMT

that works as well (along with unchecking the suppress zero values box).

What's the difference? Which is better?

thanks

Re: What's wrong with my if syntax? :(

jagan — Wed, 11 Dec 2013 10:45:06 GMT

Hi,

Qlikview suppresses zero values, if you want then

Chart Properties -> Presentation -> Uncheck Supress zero values

or use this expression

If([Account Status]='Customer','Customer', 'Non Customer')

Hope this helps you.

Regards,

Jagan.

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:47:18 GMT

yup, that's it! Thanks a lot

Re: What's wrong with my if syntax? :(

Wed, 11 Dec 2013 10:48:02 GMT

yes, that's it. I don't have any more 'helpful answer' stars to give, sorry