topic Pick Minimum Positive value in QlikView

Pick Minimum Positive value

raghavsurya — Thu, 05 Aug 2010 11:00:12 GMT

Hi All,

I am currently picking up minimum values among 3 variables with below mentioned Min function.

nummin (CVRev,CVP, CVEB, CVBV)

With one of the valubles returning negative value.... I need to pick minimum positive values. Can you please suggest how to modify the expression.

Regards,

Raghav

Pick Minimum Positive value

Thu, 05 Aug 2010 11:38:40 GMT

Hi,
Try this expression,

nummin (if(CVRev>0,CVRev),if(CVP>0,CVP),if(CVEB>0CVEB),if(CVBV>0,CVBV))

I know this might not be the most efficient way to do this but, nothing strikes me other than this.

-Haneesh

Pick Minimum Positive value

raghavsurya — Thu, 05 Aug 2010 11:43:39 GMT

Thanks Haneesh...... its working

Regards,

Raghav

Pick Minimum Positive value

Thu, 05 Aug 2010 11:52:54 GMT

Yeah, this one will definitely work. But, the expression is complex as it has to call the if condition 4 times for every row and this can consume more memory if the data volume is high.

As a best practice, it is advisable not to use such complex statements. In this case, I guess we don't have any other option now 🙂

Cheers,

Haneesh