topic Display 0 values in straight table in QlikView

Display 0 values in straight table

Fri, 30 Apr 2010 15:37:37 GMT

I need to have accounts display 0 values instead of not showing the account at all when the accounts value is 0. The other problem is I need to incorporate it into the value and I already have this included in the expression.

=if(GJACCT='230000',39033.38,sum(GJAMT))

Have no idea how to incorporate that into what I already have. Thanks in advance.

Display 0 values in straight table

Fri, 30 Apr 2010 15:43:28 GMT

You can try this.


=sum(if(GJACCT='230000',39033.38,GJAMT))

Display 0 values in straight table

fernandotoledo — Fri, 30 Apr 2010 15:48:52 GMT

For the zero problem, uncheck the "Supress Zero Values" under chart properties>presentation.

Display 0 values in straight table

Fri, 30 Apr 2010 16:02:26 GMT

I have a bookmark that has certain account numbers that are selected and if I uncheck the suppress when zero option, it shows all of my accounts. Some how I need it to show only my bookmarked accounts, but show my bookmarked accounts with 0 as a value as 0, instead of just leaving them out.

Display 0 values in straight table

Fri, 30 Apr 2010 16:04:36 GMT

With that formula it doesn't allow my if statement to work correctly.

Display 0 values in straight table

fernandotoledo — Fri, 30 Apr 2010 20:25:05 GMT

You can load a table mapping the accounts you want to show in your chart. something like


AccountMapping:
load * inline[
 Account, MappedAccount
 A, A
 B, B
 C, C
];

then you use in the chart the MappedAccount as the dimension, and check Properties>Dimensions>"Suppress When Value is Null"

Then you see only the accounts mapped in the table.