topic Re: Expression in QlikView

Expression

upaliwije — Fri, 09 Aug 2019 09:51:43 GMT

Hi Friends,

I have a pivot table in my attached Qv file. In this pivot table I have two exprression

Exp 1 SUM(NRP)

Exp 2 IF(DAILY_NRP>(NRP),SUM(NRP),SUM(DAILY_NRP))

I am expecting same total Value from both of these expression but it gives two different values. May be My Exp 2 is incorrect But I want to use Exp2 in my Pivot table. Therefore Kindly help me to correct my Exp 2.. I have attached the file pls

Re: Expression

tresB — Fri, 09 Aug 2019 09:59:22 GMT

Try this as 2nd exp:

Sum(IF(DAILY_NRP>NRP,NRP,DAILY_NRP))

Re: Expression

Gysbert_Wassenaar — Fri, 09 Aug 2019 10:02:15 GMT

You need to either use sum in the test in the if statement as well:

IF(sum(DAILY_NRP)>sum(NRP),SUM(NRP),SUM(DAILY_NRP))

Or you need to move the if inside the sum: sum(if(DAILY_NRP>NRP,DAILY_NRP,NRP). If that's what you need then replace the if with a rangemax: sum(RangeMax(DAILY_NRP,NRP))