topic Order pivot table in QlikView

Order pivot table

Anonymous — Wed, 15 Apr 2015 10:18:43 GMT

Hi,

My english is very bad, but I will try to explain my problem. I have a pivot table with 3 dimensions. The first dimension is a cyclic group.

I have 6 expresion in my pivot table. I would like order my pivot tablet by expresion as in a simple table. Can I push in a column and to order by this column?

Thanks

Re: Order pivot table

vikasmahajan — Wed, 15 Apr 2015 11:14:17 GMT

In Pivot Table you order as you desired click on column and drag where you want to kept.

Hope this help you

Vikas

Re: Order pivot table

Wed, 15 Apr 2015 11:20:13 GMT

Pls share us the sample app so that we can share better

Re: Order pivot table

Anonymous — Thu, 16 Apr 2015 08:08:36 GMT

Hi,

In Simple table, if is possible order doing click on column, but in pivot table if I do click on column... I don't get to order. It doesn't nothing

I don't want drag the columns. I would like similar performance of a simple table but in a pivot table

I add capture image

Thanks

Re: Order pivot table

Fri, 17 Apr 2015 02:34:47 GMT

Hi,

Could you use Straight table instead of pivot table.

And in properties -> sort -> select the interactive sort option then double click on the dimension where you want the order/sort.

hope i my solution suits the requirement.

Re: Order pivot table

Fri, 21 Apr 2017 20:20:01 GMT

You can use expression in sort tab. see image

Re: Order pivot table

vishsaggi — Fri, 21 Apr 2017 20:39:33 GMT

Did you try sort by Y-value. Can you share a sample app to look into?

Re: Order pivot table

Anil_Babu_Samineni — Sat, 22 Apr 2017 02:56:46 GMT

Better, It may possible. But atleast share sample data