Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The logic from a few of my nested if statements result in no loans falling into my specified loan categories. As a result, these loan categories simply do not show up at all in my object. However, I still need it to show as a zero balance (according to my defined expressions inside the QlikView).
EXAMPLE:
if(([Regulatory Report Code]=4 or [Regulatory Report Code]=5) and [Purpose Code]=79,'2107', )
.......... no loans fall into this if statement ....... so 2107 does not show in my object.
I need to reflect 2107 inside my chart with a zero loan balance.
Hi,
You can do this through the chart functions, but may be better if you can make script changes, as the formulae may get messy if you have lots of categories.
For chart functions you can use Value List in dimension along with unchecking supress zero values.
So off 1 line of data that is not category in 2107 & setting everything not 2107 to be in a 'not 2107' category I can do the following;
In this I've just reversed where the amount comes in the embedded If statements, further categories could be added, but the formulae will get messy - so scripting may be preferable unless this is a one off.
Cheers,
Chris.