topic Aggr on Above in QlikView

Aggr on Above

Newbie — Sat, 16 Nov 2024 01:50:53 GMT

I am using a Straight table with two dimension and having an expression which is using previous row value of the same column. I am able to perform this operation using Above on the same column but I am not able to Aggregate this column and then take Minimum value.

I need to apply Aggr(For DIM1,DIM2) and Min on below expression:

If( VAL <0 ,(1+Alt(Above(Column(1)),0))*Val-1
,If( (1+Alt(Above(Column(1)),0))*Val-1 < 0
,(1+Alt(Above(Column(1)),0))*Val-1
,0)
)

Re: Aggr on Above

Brett_Bleess — Mon, 09 Dec 2019 22:14:37 GMT

Best I have is a Design Blog post on the subject that may help:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Above-Function/ba-p/1465357

If you want to do some further searching in this area of Community, here is the base link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Aggr on Above

qliksus — Tue, 10 Dec 2019 09:41:35 GMT

Not sure if i have understood correctly you wanted min based on Dim1? if so you can try something like

Min ( aggr( expr , dim1))