Chart Expression

[inam]

Hello Community,

I need help . in chart expression i am using below expression but not getting 0 value .

my expression:-  =sum([Room Nights])/sum(TOTAL([Room Nights])) i am getting all value proper but not getting  0 output 

my output:- 

Expected output is :-

Note:- i convert excel formula in Qlikview 

excel formula :- =[@[Room Nights]]/SUM([Room Nights]) so i used this formula in my qlikview chart expression

 =sum([Room Nights])/sum(TOTAL([Room Nights])) its working fine but only 0 value is not getting when i load the data.

and also can i use this excel formula in qlikview script . how i use ? I tried ,but getting error in script.

[MendyS]

Hi @inam 

if i got you correct try to user this expression - 

alt(sum([Room Nights])/sum(TOTAL([Room Nights])),0)

regards, 

[inam]

Hello Mendys Thanks For reply.

code is not working . getting same ouput 0 value is missing.

[MendyS]

@inam 

OK, I need to understand better...
In which cases do you want to display 0 and which do you want empty? 
try to expand on this, will help me understand the need...
thanks