What's wrong with my if syntax? :(

[#1]

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!

Al

[#2]

Hi Al,

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

best regards

Chris

[#3]

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

[#4 · Accepted solution]

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

[#5]

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

[#6]

Hi,

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

[#7]

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

What's the difference? Which is better?

thanks

[jagan]

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.

[#9]

yup, that's it! Thanks a lot

[#10]

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