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

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
Anonymous
Not applicable
Author

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

View solution in original post

13 Replies
Not applicable
Author

Hi

   I Don't think so row wise sorting in qlikview

krishna20
Specialist II
Specialist II

Hi Tulasi,

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

Anonymous
Not applicable
Author

I am not sure,but give it a try

goto sort tab and select your expression

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

Not applicable
Author

Hi,

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

Not applicable
Author

Hi,

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

Digvijay_Singh

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

Sorting in pivot tables

krishna20
Specialist II
Specialist II

Hi ,

Is this???

Anonymous
Not applicable
Author

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
Author

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