Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sorting Problem in Pivot Table ..

Hi Frnz,

I have pivot table. In this, it is showing Top 15 Accounts. I have done pivoting on YEAR.

I need to do sorting by 2015 values ? Is it possible to show Totals in last row by year wise ?

1 Solution

Accepted Solutions
jmstekkinger
New Contributor II

Re: Sorting Problem in Pivot Table ..

Hi!
You should use the expression:

sum({<Year={"2015"}>}Sales)

Put it in your sorting tab under AccountName, make sure its descending, and that al other sorting under Year is off.

pivot.png

13 Replies
Not applicable

Re: Sorting Problem in Pivot Table ..

Hi

   I Don't think so row wise sorting in qlikview

krishna20
Valued Contributor

Re: Sorting Problem in Pivot Table ..

Hi Tulasi,

Can you please attach sample file.It will be easy to sort out your problem .

hrlinder
Honored Contributor

Re: Sorting Problem in Pivot Table ..

I am not sure,but give it a try

goto sort tab and select your expression

define: =sum({<YEAR={'2015'}>}Value) descending

Not applicable

Re: Sorting Problem in Pivot Table ..

Hi,

Please check attached Qvw. I need Sorting in 2015 values. And is it possible to show Totals in Year wise.?

Not applicable

Re: Sorting Problem in Pivot Table ..

Hi,

I need descending order for 2015 values. Please find the attached QVW.

Digvijay_Singh
Honored Contributor III

Re: Sorting Problem in Pivot Table ..

Doesn't look easy in Pivot table, below is relevant post on this -

Sorting in pivot tables

krishna20
Valued Contributor

Re: Sorting Problem in Pivot Table ..

Hi ,

Is this???

jmstekkinger
New Contributor II

Re: Sorting Problem in Pivot Table ..

Hi!
You should use the expression:

sum({<Year={"2015"}>}Sales)

Put it in your sorting tab under AccountName, make sure its descending, and that al other sorting under Year is off.

pivot.png

Not applicable

Re: Sorting Problem in Pivot Table ..

Hi,

Yes exactly i need like this. When I use this expression, I am getting like below image. I need 2015 values in top of the table.Top_Sort1.PNG

Community Browser