Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Newbie
New Contributor

Aggr on Above

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)
)

2 Replies
Highlighted
Digital Support
Digital Support

Re: Aggr on Above

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
qliksus
Valued Contributor II

Re: Aggr on Above

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

 

Min ( aggr( expr  , dim1))