Please help

Fri, 23 May 2014 03:41:44 GMT

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

Re: Please help

Fri, 23 May 2014 03:54:20 GMT

Hi guys,

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

topic Please help in QlikView

Please help

Re: Please help