Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis and Max

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

1 Solution

Accepted Solutions
rubenmarin

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

Check in attachment if this is what you want.

View solution in original post

7 Replies
rubenmarin

Hi navneet, please check attachment.

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

Not applicable
Author

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

maleksafa
Specialist
Specialist

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.

rubenmarin

Ok, something like this attachment?

Not applicable
Author

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

Thanks  and regrds

rubenmarin

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

Check in attachment if this is what you want.

Not applicable
Author

Thank you so much