topic IF Condition in QlikView

IF Condition

dseelam — Sat, 16 Nov 2024 02:23:15 GMT

Hello Qlik Folks,

I have 2 expression some thing like below

if(isnull(OldPrize),(sum(GROSS_SALES)/sum(SHIPPED_QUANTITY)),OldPrize)---Old Gross Price / Unit - this is working fine

if(isnull(AdjSale),(sum([Adj Sales])/sum(SHIPPED_QUANTITY)),AdjSale)----Old Adj Sales/Unit- Not Working

the only diff I see in both expressions GROSS_SALES vs [Adj Sales], GROSS_SALES is coming from data, [Adj Sales] is an other expression contains multiple other expressions.

[Adj Sales] defined as: [Gross Sales] - (Royalties + [PA - Acc] + [PA - UnAcc] + [Unplanned Allowances])

which is

when I elaborate it is throwing error in expression please help me to write this in proper format?

Tanks,

Re: IF Condition

Arthur_Fong — Thu, 26 Sep 2019 00:11:34 GMT

Did you notice that the error is actually coming from double commas?

Re: IF Condition

Brett_Bleess — Mon, 07 Oct 2019 18:51:02 GMT

D, did Arthur's post catch the issue? If so, please do not forget to use the Accept as Solution button on his post to mark that as the solution and give him credit.

Regards,
Brett