topic set analysis in QlikView

set analysis

Wed, 20 Feb 2013 08:47:05 GMT

Hi ,

my data looks like this

date price

1/02/2010 100

5/10/2010 500

6/01/2011 50

7/09/2011 300

8/02/2012 400

7/05/2012 600

Now i want output as

Maxdate Latestprice

7/05/2012 600

because among all dates 7/05/2012 is the maximum date and 600 is the corresponding price.

But if select any year (eg:2010)

output must be

Maxdate Latestprice

5/10/2010 500

. the latest price must show me the coresponding value of date(maxdate).

Re: set analysis

Wed, 20 Feb 2013 09:17:16 GMT

Hi Avi,

You have to use Set Analysis to get the Price for the Max(Date) in your selection. For example, like this:

Max({<Date={'$(=Max(Date))'}>} Price)

I have attached a document with an example.

Juan Gerardo

Re: set analysis

Wed, 20 Feb 2013 09:56:24 GMT

Hi Avinash,

Please Find the Attached File. Hope this helpful for you

Regards,

Nirmal.

Re: set analysis

Wed, 20 Feb 2013 10:19:17 GMT

Hi Avi,

Above Mentioned both answers are working fine

regards,

Ananth

Re: set analysis

Wed, 20 Feb 2013 10:55:08 GMT

FOR THIS OUTPUT--

maxDate	pricenew
7/5/2012	600

WRITE CODE-

LOAD

date(max(date))as maxDate,

FirstSortedValue(price,-date)as pricenew;

LOAD date,

price

FROM

(ooxml, embedded labels, table is Sheet1);

**************************************************************

FOR THIS OUTPUT, WRITECODE--