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

max value

Dear friends,

i have the following senario,

that is

year    month   amount

2008   jan            500

2008    feb           1000

2009    mar           600

2009     apr           1500

2012     sep            2200

2012     oct              3000

2012     nov             4000

2012      dec             5000

so i need each year what month have a max value dynamicallty i need to know

how

4 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution, use FirstSortedValue() for this.

Use Year as dimension and =FirstSortedValue(month, -amount) as expression.

Regards,

Jagan.

Not applicable
Author

Thanks for having Reply,

but my requirement is different

that mens in bar chart i want to show current year which month has max value and same way prev year which month has max value

u got my req

Not applicable
Author

hi

try this in your script.

a:

LOAD   year,

   

     max(amount)

FROM

C:\Users\vishwaranjan\Desktop\test_4.xlsx

(ooxml, embedded labels, table is Sheet1) Group by year ;

Not applicable
Author

Hi,

Check out the attached one..

hope it helps u..