topic Re: Sort total Coulmn in QlikView

Sort total Coulmn

Thu, 03 Jul 2014 09:19:48 GMT

Hello all,

How to sort total column in pivot table ,as shown in image ,i need to sort the

Total column in descending order (Like 1411, 643, 381)?????

Re: Sort total Coulmn

whiteline — Thu, 03 Jul 2014 09:37:23 GMT

Hi.

Go to the sorting tab, select CallSource dimension. Toggle override group sorting order. Then type the expression you want to be used for sorting.

Re: Sort total Coulmn

SunilChauhan — Thu, 03 Jul 2014 09:39:36 GMT

chart properties-> sort ->select dimension Callsource(or groupname)-> expression ->[Total]

see the attched example

Re: Sort total Coulmn

Thu, 03 Jul 2014 09:42:21 GMT

thanks sunil,,,
but wherez attached sample ??

Re: Sort total Coulmn

whiteline — Thu, 03 Jul 2014 09:45:32 GMT

Open a full theme view, the attachments are hidden when you look through inbox.

Re: Sort total Coulmn

stigchel — Thu, 03 Jul 2014 09:48:52 GMT

Sorry, but you cannot reference the expression in the sort expression (try changing the sort order and you will see it does not change). Instead copy the complete calculation in the sort expression.

Re: Re: Sort total Coulmn

SunilChauhan — Thu, 03 Jul 2014 09:49:04 GMT

i am attaching again

Re: Re: Sort total Coulmn

SunilChauhan — Thu, 03 Jul 2014 09:50:31 GMT

We can use Expression name over that object .it will work. you may try this

Re: Sort total Coulmn

Gysbert_Wassenaar — Thu, 03 Jul 2014 09:58:20 GMT

In the example below the expression used is count(Sales). The table is sorted by Product using the expression aggr(count(Sales),Product in descending order.

Re: Sort total Coulmn

stigchel — Thu, 03 Jul 2014 10:03:52 GMT

Have you tried changing the sort order from ascending to descending in your example?

Re: Sort total Coulmn

SunilChauhan — Thu, 03 Jul 2014 10:14:29 GMT

accept my apologies.Ya you are correct .

Re: Sort total Coulmn

Greg_Williams — Thu, 03 Jul 2014 10:14:31 GMT

Will this work? View attachment.

Note - To dynamically sort, you will either need to create a variable and use a button to change the sort order OR you can add a Fast Type Change type of Straight Table and sort the table in a desired fashion.

Re: Sort total Coulmn

Fri, 04 Jul 2014 01:41:17 GMT

I am using Cyclic Group (Of Dimension ) In place of just one Dimension Product,How Can I do it for Cyclic group ??