topic Re: Error in expression in QlikView

Error in expression

tim_leijen — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Yesterday I created the expression below,

=IF((sum({<GL_1={VOL},Dimension={LY}>}Data)=0) ,[VOL ACT],0)

After copying the table to excel, I checked and the formula is working properly.

The only issue remains, the 0's aren't a number, and so QV can't calculate. What am I doing wrong in my formula?

Putting the 0 between " " or ' ' doesn't seem to solve the issue. Any ideas?

Re: Error in expression

Anonymous — Wed, 19 Sep 2018 08:42:38 GMT

did you Format your number in tab "Number" to Integer?

if stil not working use num

=num(IF((sum({<GL_1={VOL},Dimension={LY}>}Data)=0) ,[VOL ACT],0),'#.##0')

Re: Error in expression

tim_leijen — Wed, 19 Sep 2018 08:47:11 GMT

Thanks for your reply Rudolf, doesn't work though... The settings for all my formulas are the same, all on "Fixed to" which does work for the others, tried all the other format settings as well though..

Now I just tried your formula, and still no totals, so there's still an issue with the 0's.....

Re: Error in expression

Anonymous — Wed, 19 Sep 2018 09:02:25 GMT

I think I is not considered as number as there is no operation, you are returning [VOL ACT] or 0 but [VOL ACT]is not supposed to be always a number.

You should try:

IF((sum({<GL_1={VOL},Dimension={LY}>}Data)=0) ,sum([VOL ACT]),0)

Re: Error in expression

tim_leijen — Wed, 19 Sep 2018 09:04:39 GMT

Sorry Bobbyraj, didn't work either... :S

Re: Error in expression

tim_leijen — Wed, 19 Sep 2018 09:08:10 GMT

I corrected the expression, instead of calculating with another column, I corrected it to the one below, but still doesnt work

IF((sum({<GL_1={VOL},Dimension={LY}>}Data)=0) ,sum({<GL_1={VOL},Dimension={ACT}>}Data),0)

Re: Error in expression

raman_rastogi — Wed, 19 Sep 2018 10:58:37 GMT

Try this

Sum({<Data = {"=Sum({< GL_1={'VOL'},Dimension={'LY'>}Data) =0"}> }[VOL ACT])

Regards

Raman

Re: Error in expression

tim_leijen — Wed, 19 Sep 2018 11:00:03 GMT

Hi Raman, just tried, but also this one isn't working.... thanks for your suggestion anyway!