The equivalent of the 'for' operator in qlikview

[#1]

Could someone please let me know if there is an equivalent of a 'for' operator in qlikview?

I have 5 dimensions:

Year,wk,page,cell.Offer

and 1 metric: Sales

I am trying to find the max (Sales for Cell)

Can someone help me out?Thank you in advance.

[boorgura]

are you talking about "group by"?

And do you want the max value calculated on the UI or in the script?

[#3]

Yea,so i want to find the max of sale for each 'cell' dimension.

And yes, I want this in the UI..

Thanks,

Prasad

[johnw]

I'm not sure what you want. If you just want a chart of the cells with max sales for each:

dimension = cell
expression = max(Sales)