Please help

[#1]

Hi Qlikies,

I have the below table:

Quantity	Quarter	QRank	Object
10	2012-Q1	1	PP
20	2012-Q2	2	PP
30	2012-Q3	3	PP
15	2012-Q4	4	PP
25	2012-Q1	1	PP
40	2012-Q1	1	PP
30	2012-Q2	2	PP
70	2012-Q3	3	PP

For the Expression'Sum({<Object={'PP'}>}Quantity)'  if i select 1 Quarter it showsSum of Quantity for that particluar Quarter.

Now, if i select 2 Quarters then its hows sum of Quantity for that 2 Quarters, but i want to show it to the Quantity for 1 Quarter only based on max(rank). Please help.

I am using this expression but its not working: Sum({<Object={'PP'},QRank={=Max(QRank)}>}Quantity).

[#2 · Accepted solution]

Hi guys,

got the answer:=Num(Sum({<Object={'PP'},Qrank={$(=Max(Qrank))}>}Quantity),'###,###,###')