topic max value in QlikView

max value

Sun, 03 Feb 2013 15:09:57 GMT

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

jagan — Sun, 03 Feb 2013 18:52:40 GMT

Hi,

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

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

Regards,

Jagan.

Mon, 04 Feb 2013 10:12:11 GMT

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

Mon, 04 Feb 2013 10:34:57 GMT

try this in your script.

LOAD year,

max(amount)

FROM

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

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

Mon, 04 Feb 2013 11:54:21 GMT

Hi,

Check out the attached one..

hope it helps u..