topic Re: Chart Expression in App Development

Chart Expression

inam — Fri, 15 Nov 2024 21:42:19 GMT

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.

Re: Chart Expression

MendyS — Thu, 08 Jun 2023 06:57:53 GMT

Hi @inam

if i got you correct try to user this expression -

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

regards,

Re: Chart Expression

inam — Thu, 08 Jun 2023 10:04:22 GMT

Hello Mendys Thanks For reply.

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

Re: Chart Expression

MendyS — Thu, 08 Jun 2023 11:12:00 GMT

@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