topic Re: Sorting in Pivot Table by Order #? in QlikView

Sorting in Pivot Table by Order #?

Fri, 20 Nov 2020 18:02:30 GMT

Hi guys,

I have a Pivot table with my dimensions as: Customer, OrderID, Order Date and Product. My expressions are Sales and Quantity. I would like to sort the table by Order ID in ascending order. I have selected the Sort tab in the Properties dialog box and then clicked on the dimension and changed it to numeric value in ascending order, clicked apply and there is no change. If anyone could help me with this I would greatly appreciate it.

Re: Sorting in Pivot Table by Order #?

jzimolong — Sun, 18 Jan 2015 00:18:13 GMT

Perhaps the following post will help you. Check out the sample .qvw files

http://community.qlik.com/thread/95788

Re: Sorting in Pivot Table by Order #?

Anonymous — Sun, 18 Jan 2015 14:53:21 GMT

Try to promote OrderID in the first position (above other dimensions and expressions) in sort tab and then click ascending order for numeric values (and A-Z for text... maybe OrderId is not interpreted as numeric)

Hope this helps you

Re: Sorting in Pivot Table by Order #?

engishfaque — Sun, 18 Jan 2015 19:32:30 GMT

Dear Chase,

Please share your sample data.

Kind regards

Ishfaque Ahmed

Re: Sorting in Pivot Table by Order #?

krishna20 — Mon, 19 Jan 2015 06:20:41 GMT

Hi Miller,

In the Pivort table choose sort tab ,then select your dimension field.If the expression option is enabled ,place your Dimension field there and select ASEC or DESC from dropdown.

If Expression option is disable go to Y-Value option ,then select ASEC or DESC from Dropdown.

Hope this helps.

Regards

Krishna

Re: Sorting in Pivot Table by Order #?

avinashelite — Mon, 19 Jan 2015 06:23:32 GMT

Hi Chase,

In the sort tab promote your ORDERID to top and select the sorting order, if not select the Expression option in the sort tab and write the sorting expression.

Re: Sorting in Pivot Table by Order #?

Mon, 19 Jan 2015 20:45:43 GMT

I need the pivot table to be expanded, but I need it to be sorted in ascending order of total sales of each customer. I have attached a snapshot of the final product. Because I am using the Qlikview Personal Demo Edition to complete this project, I am unable to view shared .qvw files. If anyone has any suggestions as to how to achieve this I'd greatly appreciate it.

Thanks