Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to apply grouping in qlikview expression?

Hi,

Can anyone help, please?

I have some fields

field1

field2

field3

field4

field5

....

I need field5 for max(field4) group by field1, field2, filed3 in a chart. 

Thanks!

1 Reply
Not applicable
Author

Hi,

Try like (As dimnsion):

aggr(if(field4= max(field4), field5),field1,field2,field3)

Regards

Rahul Lakhina