Discussion board where members can get started with QlikView.
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:
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?
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.