topic Re: Set analysis and Max in QlikView

Set analysis and Max

Mon, 24 Nov 2014 11:32:04 GMT

I have three dimensions

DATE, PHASE , GENERATION

01/01/2014 Delhi 10000

01/01/2014 Newyork 500

01/01/2014 Banglore 6000

17/11/2014 Delhi 3000

17/11/2014 newyork 9000

17/11/2014 Banglore 3000

NOW I WANT TO know on which date my generation was maximum for a particular phase ..

please help

Re: Set analysis and Max

rubenmarin — Mon, 24 Nov 2014 11:51:00 GMT

Hi navneet, please check attachment.

There is one table with GENERATION as expression and other as dimension, formula to background color is the same.

Re: Set analysis and Max

Mon, 24 Nov 2014 12:11:46 GMT

hey rubeen,

Your answer is helpful but i dont want any other dates

in a table i want first phase,

second date of max generation of that phase

third generation

Output:

Phase Date Generation

Delhi 01/01/2014 10000

Newyork 17/11/2014 9000

Banglore 01/01/2014 6000

Thats it!!!

Please help

Re: Set analysis and Max

maleksafa — Mon, 24 Nov 2014 12:14:28 GMT

from the example provided by Ruben, change the expression in the in the first chart to If(GENERATION=Aggr(NODISTINCT Max(GENERATION), PHASE),GENERATION)

and modify the sort tab if you want them in a specific order.

Re: Re: Set analysis and Max

rubenmarin — Mon, 24 Nov 2014 12:15:26 GMT

Ok, something like this attachment?

Re: Re: Re: Set analysis and Max

Mon, 24 Nov 2014 12:32:25 GMT

i TRIED ON MINE BUT ITS NOT WORKING .... I AM ATTACHING A DUMP

Thanks and regrds

Re: Re: Re: Re: Set analysis and Max

rubenmarin — Mon, 24 Nov 2014 12:42:31 GMT

Works for me, and in Excel max values are green, check to supress null values?

Check in attachment if this is what you want.

Re: Set analysis and Max

Mon, 24 Nov 2014 13:09:11 GMT

Thank you so much