topic Re: Sorting in Pivot Table/Chart in QlikView

Sorting in Pivot Table/Chart

Tue, 22 Oct 2013 20:01:38 GMT

I want to show employee salaries sorted in descending order in each month in chart. Please see the attached QVW file.

I tried Aggr() and FirstSortedValue() but couldn't get it done, may be I wasn't using the right expressions.

This chart is dynamic and I don't know the exact salaries. The ones that I mentioned are very simple like 10,20, etc so sorting salaries by a divisor won't work. Also, as chart is dynamic I don't have the option of creating an INLINE table for salary ranking.

Any help will be appreciated. Many thanks.

Re: Sorting in Pivot Table/Chart

Tue, 22 Oct 2013 23:52:26 GMT

Kasim;

Check this.

best regards.

Re: Re: Sorting in Pivot Table/Chart

Wed, 23 Oct 2013 05:48:28 GMT

Hi...

Is this what you were looking for??

Re: Sorting in Pivot Table/Chart

Wed, 23 Oct 2013 08:42:19 GMT

Thanks Claudio for your answer, but unfortunately we have got varying salaries in different months for same individuals. For example, Jan-13 David 50, Feb-13 David, 40 .

Please load the table below and see

HR:

LOAD * INLINE [
Month-Year, Names, Salary
Jan-13, David, 50
Jan-13, John, 20
Jan-13, Rob, 30
Jan-13, Steve, 10
Feb-13, David, 40
Feb-13, John, 30
Feb-13, Rob, 30
Feb-13, Steve, 10
Feb-13, Phil, 200
Mar-13, David, 40
Mar-13, John, 20
Mar-13, Rob, 30
Mar-13, Steve, 10
Mar-13, Matt, 50
Apr-13, David, 40
Apr-13, John, 20
Apr-13, Rob, 30
Apr-13, Steve, 10
May-13, David, 40
May-13, John, 20
May-13, Rob, 30
May-13, Steve, 10
May-13, Phil, 100
Jun-13, David, 40
Jun-13, John, 20
Jun-13, Rob, 30
Jun-13, Steve, 10
];

Re: Sorting in Pivot Table/Chart

saumyashah90 — Wed, 23 Oct 2013 08:45:36 GMT

hope this helps you

Re: Sorting in Pivot Table/Chart

Wed, 23 Oct 2013 08:55:12 GMT

Thanks Saumya for your answer, but unfortunately we have got varying salaries in different months for same individuals. For example, Jan-13 David 50, Feb-13 David, 40 .

Please see my reply to Claudio