Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie
Contributor II
Contributor II

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

Labels (3)
2 Replies
Brett_Bleess
Employee
Employee

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
qliksus
Specialist II
Specialist II

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

 

Min ( aggr( expr  , dim1))