topic Expression help in QlikView

Expression help

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

Hi,

I have the below expression.

(Sum(unpriced_lots)/NetWorkDays(today()+2,final_pricing_dt))*3

I would like to add an IF statement that says IF Diminishing Balance Contract = Y, then

(Sum(unpriced_lots)/NetWorkDays(today()+2,final_pricing_dt))*3 , IF Diminishing Balance Contract = N then Sum(unpriced_lots)

Any help would be appreciated.

Regards,

Daniel

Anonymous — Thu, 18 May 2017 16:33:07 GMT

=if([Diminishing Balance]='Y',

(Sum(unpriced_lots)/NetWorkDays(today()+2,final_pricing_dt))*3,

Sum(unpriced_lots))

danielnevitt — Thu, 18 May 2017 16:46:21 GMT

Thanks for your help

Anonymous — Thu, 18 May 2017 16:47:45 GMT

No problem. Glad you got what you needed.