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: 
qv_testing
Specialist II
Specialist II

Need help??

Hi Community,

PFA,

is it possible Expression Value sort in pivot table...

i want to sort Qty column (asc or desc)

Capture1.PNG

Thanks in Advance.......

1 Solution

Accepted Solutions
ashwanin
Specialist
Specialist

Hi,

Its possible.

Go to chart properties-->Short --> add the field with which you want to short

Have updated your qvw with this. Please find.

View solution in original post

5 Replies
Not applicable

For pivot table, i believe its not possible, but in straight table you can do it.

qv_testing
Specialist II
Specialist II
Author

Straight table possible i know that.. but

i need in pivot table..... I have Expandable and collapsible functionality..

is there any solution...!!!!!

kji
Employee
Employee

Try setting sort by expression for your dimension using the same expression as the column you want sorted.

(this probably belongs under QlikView, not Qlik Sense).

ashwanin
Specialist
Specialist

Hi,

Its possible.

Go to chart properties-->Short --> add the field with which you want to short

Have updated your qvw with this. Please find.

MK_QSL
MVP
MVP

Go to Sort Tab

Select Name

Expression (ASC or DESC as per you want)

Type below in expression

sum(Qty)