Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
PFA,
is it possible Expression Value sort in pivot table...
i want to sort Qty column (asc or desc)
Thanks in Advance.......
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.
For pivot table, i believe its not possible, but in straight table you can do it.
Straight table possible i know that.. but
i need in pivot table..... I have Expandable and collapsible functionality..
is there any solution...!!!!!
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).
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.
Go to Sort Tab
Select Name
Expression (ASC or DESC as per you want)
Type below in expression
sum(Qty)