topic How to capture null value in following example in QlikView

How to capture null value in following example

kamalqlik — Tue, 20 Sep 2011 06:21:02 GMT

Hi Friends

I am using the four fields as Revenue,Expenses,Tax and Year in the table.

We are using a expression Income as (Revenue -Expenses-Tax) ,there is one null value in tax.What i want is that when we run a loop and as it identify the null value,the loop breaks and calculate the income for the data before the null value and will show the income for the data after the null value as 0.

I am attaching my excel sheet with this.

Thanks in advance

How to capture null value in following example

kaushiknsolanki — Tue, 20 Sep 2011 06:58:46 GMT

HI,

Can you tell us in what way you are using the attahced excel. What kind of chart you are creating. Also tell us what you want with example.

Regards,

Kaushik Solanki

How to capture null value in following example

kamalqlik — Tue, 20 Sep 2011 07:13:02 GMT

Hi Kaushik

I just want that in a straight table the data should be displayed with calculations upto the row where the null value in Tax field is captured. You can use any other chart also.

I want that Income field should show 0 as soon as the null value in the Tax field is captured.

Thanx.

How to capture null value in following example

SunilChauhan — Tue, 20 Sep 2011 07:17:24 GMT

use thee formula beelow in expression

(Revenue -Expenses-if(isnull(tax)=0,tax,0))

(Revenue -Expenses-if(len(tax)>0,tax,0))

How to capture null value in following example

kamalqlik — Tue, 20 Sep 2011 07:33:00 GMT

Hi Sunil,I am not getting the results which we want to get.The following expression is also showing the result for the null values and the for the data after the null value.

How to capture null value in following example

SunilChauhan — Tue, 20 Sep 2011 08:07:08 GMT

use thee formula beelow in expression

(Revenue -Expenses-if(isnull(tax)=0,tax))

(Revenue -Expenses-if(len(tax)>0,tax))

sorry if its not work

hopee someone will hep you

Re: How to capture null value in following example

Anonymous — Mon, 26 Sep 2011 12:56:15 GMT

Sunil's formula's are correct.

Just make sure "Tax" is with a capital, like in your Excelfile

so:

(Revenue -Expenses-if(len(Tax)>0,Tax))