topic Re: Problems with if statement in load script in QlikView

Problems with if statement in load script

Wed, 16 Aug 2017 09:21:42 GMT

Hello,

due to Performance reasons I am trying to move some expressions into the load script. Somehow I always encounter issues with the if Statement. In my qvw file I use the following Set Analysis Expresssion which works perfectly fine:

round(aggr(sum( {$<ProductionKey={'Prod'}>}ProductionQty),ProductionSegmentID),0.01)

now I am trying to do the same in the load script with an if Statement:

Load

ProductionSegmentID,

if(ProductionKey = 'Prod',round(sum(ProductionQty),0.01)) as ProductionSegmentQuantity

resident Data Group by ProductionSegmentID;

Any ideas what I´m doing wrong would be highly appreciated.

Thanks

Stefan

Re: Problems with if statement in load script

sunny_talwar — Wed, 16 Aug 2017 13:39:34 GMT

Try this

LOAD ProductionSegmentID,

Round(Sum(If(ProductionKey = 'Prod', ProductionQty)),0.01) as ProductionSegmentQuantity

Resident Data

Group by ProductionSegmentID;

Re: Problems with if statement in load script

marcus_sommer — Wed, 16 Aug 2017 13:52:38 GMT

A different approach might be:

Load

ProductionSegmentID,

round(sum(ProductionQty),0.01) as ProductionSegmentQuantity

resident Data where ProductionKey = 'Prod' Group by ProductionSegmentID;

- Marcus

Re: Problems with if statement in load script

Wed, 16 Aug 2017 14:05:53 GMT

Hello Sunny,

thanks a lot for the Help. SOmetimes you just don´t see the tree even though you are in the forest

Regards

Stefan

Re: Problems with if statement in load script

Wed, 16 Aug 2017 14:07:53 GMT

Hello Marcus,

thanks for the Input. The Where Statement won´t work in this case, because some rows which I also Need in the table are not flagged as ProductionKey = Prod.

Regards

Stefan