topic Re: If (Sum()) in load script in QlikView

If (Sum()) in load script

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

Hello,

I want to load the below script but it shows error.

Can someone helps?

LOAD

If (sum(If (IsNull(@22), 0 ,@22))>0, @20, 'Non_used') as Part#,

Re: If (Sum()) in load script

tresB — Thu, 18 Jul 2019 06:23:37 GMT

Do you really need sum() here? If yes, may be you are missing Group By clause with it? If that is not the case, try to share more info on error and script snippet you are using, may be a screen shot.

Re: If (Sum()) in load script

wendytham — Thu, 18 Jul 2019 07:11:59 GMT

I would like to categorize both of the group as below, but it keep showing error in the script.

If(Sum(@22)>0,Count(DISTINCT @2),0)as PartUsedQty,

If(Sum(@22)=0,Count(DISTINCT @2),0)as NonPartUsedQty,

Re: If (Sum()) in load script

Brett_Bleess — Tue, 13 Aug 2019 13:17:27 GMT

Wendy, the best thing would be if you can attach what you have in the way of an app, or a smaller sample that shows the issue, as it is a bit difficult to try to help when we do not even have the error message being thrown... I am assuming you are just getting 'bad expression' in the expression editor, but not sure... If you can attach an app, folks can check the data model and everything to try to figure out what is going wrong.

Regards,
Brett