Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sharynwhite
Contributor
Contributor

How can I show a zero loan balance in my object, when no loans fall into my if statement logic ?

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.  

 

 

 

 

 

  

1 Reply
chrismarlow
Specialist II
Specialist II

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;

20181204_1.png

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.