aggr(if() expression not working

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

Hi All,

I have an aggr expression in pivot table(in dimension) to calculate trend for all the months in. My expression works to show bad trend, but not in other as per the conditions below.

The below expression is test column in table, it gives value 1 for down trend and 0 for up and horizontal trend, so the test is successful, but my main expression is not working.

if(not IsNull(Trim(After(sum(Budget)/sum(Sales)))),

If(round(Alt(After(Sum(Budget)/Sum(Sales)), 0),0.0001) <

(Round(Alt(Sum(Budget)/Sum(Sales), 0),0.0001) - (Round(Alt(Sum(Budget)/Sum(Sales), 0),0.0001)*0.005)),1,0),0)

Please help!

topic aggr(if() expression not working in QlikView

aggr(if() expression not working