topic Re: How to select second maximum value in QlikView

How to select second maximum value

Anonymous — Thu, 08 May 2014 05:31:47 GMT

We have list of years followed by

2014

2013

2012

2011

We want compare 2014 and 2013.how to select second maximum value from

Kindly advise me

Re: How to select second maximum value

tresB — Thu, 08 May 2014 05:33:29 GMT

Max(Field, 2) // '2' is the rank

Re: How to select second maximum value

Anonymous — Thu, 08 May 2014 05:37:09 GMT

Thanks,

but it not working.This is my expression

"If(Year=Max(Year,2),Year,(Sum(HWB_WT/1000)+Sum(VOLUME_IN_TEUS)))"

Re: How to select second maximum value

kaushiknsolanki — Thu, 08 May 2014 05:39:29 GMT

Hi,

Create a variable and put =max(Year,2) there, and then use the variable in your if statement.

"If(Year=variable,Year,(Sum(HWB_WT/1000)+Sum(VOLUME_IN_TEUS)))"

Regards,

Kaushik Solanki

Re: How to select second maximum value

tresB — Thu, 08 May 2014 05:41:09 GMT

Max( ,2) is fine. The issue is how and where you use it. Is it a chart or text box? If chart, what are the dimensions..., so many questions ! Better, try to share your sample qvw.

Re: How to select second maximum value

Anonymous — Thu, 08 May 2014 05:45:28 GMT

still same issue.it is not working

Re: How to select second maximum value

its_anandrjs — Thu, 08 May 2014 05:47:41 GMT

Did you try this

If(Year = Max(Year)-1,Year,(Sum(HWB_WT/1000)+Sum(VOLUME_IN_TEUS)))

Re: How to select second maximum value

Anonymous — Thu, 08 May 2014 05:52:12 GMT

yes,

but not working anand.

Re: How to select second maximum value

SunilChauhan — Thu, 08 May 2014 06:11:18 GMT

try this

let vmax2=Max(Year,2);

if( Year=$(vmax2),Year,(sum(HWB_WT/100))+sum(VOLUME_IN_TUES)))

or attched sample

hope this helps

Re: How to select second maximum value

Anonymous — Thu, 08 May 2014 06:43:25 GMT

Hi,

Sorry this is not working.

how to compare current and previous year value.

Re: How to select second maximum value

tresB — Thu, 08 May 2014 06:47:59 GMT

Had you been able to upload a sample qvw, this thread would have been much shorter with you got the answer.

Re: How to select second maximum value

PradeepReddy — Thu, 08 May 2014 07:10:14 GMT

I am assuming that you are showcasing the comparsion in BarChart. We can achieve this using set analysis.

Method-1:

1) Take a calculated dimension as

if(CLNDR_YR>=$(=max(CLNDR_YR,2)),CLNDR_YR)

2) take the expression as

sum(HWB_WT/100)+sum(VOLUME_IN_TUES)

3) Suppress the NULL value

Method-2:

1) Take the CLNDR_YR as dimension

2) write the expression as bellow

(Sum({$<CLNDR_YR={'>=$(=max(CLNDR_YR,2))'}>}HWB_WT)/100)+(sum({$<CLNDR_YR={'>=$(=max(CLNDR_YR,2))'}>}VOLUME_IN_TUES))

Regards,

Pradeep