topic Re: Sort in Pivot table in QlikView

Sort in Pivot table

narender123 — Mon, 10 Jul 2017 12:24:17 GMT

Hi Team,

I have a pivot table with 2 columns and 2 expression.

Like:

Col1 Col2 exp1 exp2

I want the exp2 in descending order.

When the pivot table not expended then the exp2 shows the amount in descending order. But when i expend the Pivot table then amount not show in descending order.

I set the expression in sort but didnt get the result as i want.

Please let me know how to show the amount in descending order when pivot table is fully expended.

Thanks,

Narender

Re: Sort in Pivot table

prma7799 — Mon, 10 Jul 2017 12:28:34 GMT

Put exrp2 in all dimension for sorting as Descending and try

or share some sample app

Re: Sort in Pivot table

narender123 — Mon, 10 Jul 2017 12:35:59 GMT

Thanks P M,

I tried the same but didn't get success.

I cant share the data.

Re: Sort in Pivot table

antoniotiman — Mon, 10 Jul 2017 12:37:08 GMT

Hi,

sort order is calculated once per graph (Total Expression).

So maybe exp2 -> 1st in Col2 /A and 2nd in Col2/B.

Regards,

Antonio

Re: Sort in Pivot table

narender123 — Mon, 10 Jul 2017 12:48:25 GMT

Hi Antonio,

I didn't get your point "Col2 /A and 2nd in Col2/B."

Re: Sort in Pivot table

narender123 — Tue, 11 Jul 2017 07:14:44 GMT

Anyone knows how i can sort in pivot table?

Re: Sort in Pivot table

prma7799 — Tue, 11 Jul 2017 07:21:48 GMT

share some scramble data it will might help.

Re: Sort in Pivot table

passionate — Tue, 11 Jul 2017 11:49:50 GMT

Hi,

I am getting the pivot table second expression sorted.

You have only sorted the first dimension by expression.

But, Put same sorting by expression to second dimension as well

Regards,

Pankaj

Re: Sort in Pivot table

balar025 — Tue, 11 Jul 2017 11:57:05 GMT

Hi Narender,

Pivot table work on group wise sorting. So, you need to sort one by one by dimensions.

Thanks

Ravi Balar

Re: Sort in Pivot table

narender123 — Thu, 13 Jul 2017 10:52:15 GMT

I did the same but no success.

Thanks

Re: Sort in Pivot table

narender123 — Thu, 13 Jul 2017 10:52:51 GMT

I did the same as Pankaj suggested but no success.

Thanks

Re: Sort in Pivot table

balar025 — Thu, 13 Jul 2017 10:56:37 GMT

Can you please share a sample app?

Re: Sort in Pivot table

Anonymous — Fri, 14 Jul 2017 07:00:45 GMT

Hi Narender,

How are you??

when no cloumns are expanded chart dimnesionality is 1 and when you expand second dimensionality

increases and from 1 it become 2.

in your sort tab where you are writing expresion sum({<Flag={8}>} TAX_AMOUNT )

write if( dimensionality()=2, Rank(sum({<Flag={8}>} TAX_AMOUNT ) ) and check expression check box

and keep selecting drop down as descending for both of your expression .

It may work.

Thanks

Anant Dubey

9718365394