topic Re: Need help?? in QlikView

Need help??

Nagaraju_KCS — Mon, 15 Sep 2014 10:18:06 GMT

Hi Community,

PFA,

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

i want to sort Qty column (asc or desc)

Thanks in Advance.......

Mon, 15 Sep 2014 10:27:35 GMT

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

Nagaraju_KCS — Mon, 15 Sep 2014 10:30:40 GMT

Straight table possible i know that.. but

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

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

kji — Mon, 15 Sep 2014 10:38:29 GMT

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 — Mon, 15 Sep 2014 10:38:35 GMT

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 — Mon, 15 Sep 2014 11:00:12 GMT

Go to Sort Tab

Select Name

Expression (ASC or DESC as per you want)

Type below in expression

sum(Qty)