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

Searching for multiple max values

Hi guys!

I have a ploblem here. Need to find max values in 2 fields simultaneously, I have a table as follows:

Employee        Account            Months            Data

Name1            Account1          January             0,42

Name1            Account2          January             0,5          

Name1           Account3           February             1

Name2           Account2           March                 1

Name2           Account2           April                    1

Name2          Account2           January               0,3

Name3          Account4           April                    0,7

Name3          Account5           April                    0,3

I need to find the Max Month and Max data if I have January as max months for 2 times as inthe first case. I need this to get the correct Accaunt Name.

Please help!

0 Replies