topic Re: Null Value in QlikView

Null Value

upaliwije — Thu, 19 Nov 2015 10:24:29 GMT

I have pivot table in my QV document.

BRANCH	SUM(AMOUNT)
A	15,000
B	15,000
C	95,000
D	15,000
E	110,000
F.	15,000
G	124,000

In addition to the above there are some other Branches in my table where the value is null. I want to show all records in my pivot table and null vale as 0(zero) . Pls help me to get it done

Thanks

Re: Null Value

tamilarasu — Thu, 19 Nov 2015 10:27:15 GMT

Go to presentation tab and uncheck the Suppress - Zero values option.

Re: Null Value

HirisH_V7 — Thu, 19 Nov 2015 10:27:36 GMT

Hi,

Can You post your sample App and Elaborate your requirement.

By the way ,

In your Expression at presentation For null values '-' instead of this keep '0'

Thanks,

Hirish

Re: Null Value

Thu, 19 Nov 2015 10:30:47 GMT

Hi Upali,

Interestingly, I read a fascinating piece by another contributor (i.e. I can't claim credit for this!) recently which should hopefully be of use.

Hope it helps,

Regards,

Jason

Accumulations

Re: Null Value

upaliwije — Thu, 19 Nov 2015 10:50:04 GMT

still zero values do not appear

Re: Null Value

tamilarasu — Thu, 19 Nov 2015 10:55:43 GMT

Try the below expression,

If(SUM(AMOUNT)>0, SUM(AMOUNT),0)

Re: Null Value

tamilarasu — Thu, 19 Nov 2015 10:56:45 GMT

Just noticed, goto dimension tab Nd uncheck supress when value is null option for the branch dimension.

Re: Null Value

avinashelite — Thu, 19 Nov 2015 11:02:17 GMT

Try like this :

1.Set your null values as ZERO using the conditional statement or len function

2.In the Presentation tab un check the suppress Zero values option this should help you

Re: Null Value

raghvendrasingh — Thu, 19 Nov 2015 11:05:55 GMT

Hi,

Please find attached qvw, hope this will help.

Regards,

Raghvendra