topic Sorting problem in pivot table in QlikView

Sorting problem in pivot table

harleen_singh — Tue, 15 Mar 2011 15:50:41 GMT

Hello,

i want to do sorting in pivot table according to third dimension only

dim1, dim2, dim3

i want to do sorting with dim3 only not with dim1,dim2.

I have checked sorting to dim3 in sort tab and unchecked in dim1 and dim2.

but its not sorting down??

and according to requirement i cannot change order of dimensions

thanks

Lavi

Sorting problem in pivot table

harleen_singh — Wed, 16 Mar 2011 10:00:10 GMT

Any answer??

Sorting problem in pivot table

Wed, 16 Mar 2011 10:24:19 GMT

Sorting problem in pivot table

Wed, 16 Mar 2011 10:25:49 GMT

For That go to "sort" tab there select dimension which one you want to sort then check "override group sort order" and sort whatever you want.

Sorting problem in pivot table

Anonymous — Wed, 16 Mar 2011 10:34:25 GMT

Lavi,
Pivot table is always sorted by 1st dimension. That said, the sort order may be defined by expression, which you can be, in your case
=dim3
See my post with more examples here: http://community.qlik.com/media/p/68595.aspx

Sorting problem in pivot table

harleen_singh — Wed, 16 Mar 2011 10:35:44 GMT

Srividhya,

Thanks for instruction. I tried but in sort tab "override group sort order" option is disabled??

thanks

Lavi

Sorting problem in pivot table

Wed, 16 Mar 2011 10:42:06 GMT

Hi Lavi

If its s disabled means "sort by" option is abled to access so sort there.

If "sort by" option is disabled means thath time only we need "override group sort order"

Just try it

its just a guess

Sorting problem in pivot table

harleen_singh — Wed, 16 Mar 2011 10:59:50 GMT

Thanks for that article Michael.

Srividhya,

sorry I didn't understood your last post. I wanted to say that i cannot see check box of "override group sort order". So how can i tick it??

See the following screenshot

Thanks

lavi

Sorting problem in pivot table

Wed, 16 Mar 2011 11:33:20 GMT

hi lavi,

do one thing, in the sorting tab, just promot your dim3 to top. bcoz, it performs sorting only on the dimension, which is on top of the list in the sort tab.

try it once..

regards

A'run'

Sorting problem in pivot table

harleen_singh — Wed, 16 Mar 2011 11:44:02 GMT

A'run',

thanks but Can u see promote option in the above screenshot?.

In pivot table you cannot promote dimensions so i cannot try your suggestion. Its available in straight table.

thanks

Lavi

Sorting problem in pivot table

Wed, 16 Mar 2011 11:50:48 GMT

hi..

promote ur dimension in dimensions tab. means, add ur dim3 first when you are adding dimensions in the dimension tab.

may be it works..

regards

A'run'

Sorting problem in pivot table

harleen_singh — Wed, 16 Mar 2011 11:55:14 GMT

Arun,

that i know. It is possible. But, my client wants to display sorting in third dimension only. and i don't think it seems to be possible according to Michael.

thanks

Sorting problem in pivot table

Anonymous — Wed, 16 Mar 2011 12:21:42 GMT

Lavi,
I didn't say that there is no solution.
It is sorted by the 1st dimension, but in "Sort By" (for this dim1) you can use Expression = dim3

Sorting problem in pivot table

harleen_singh — Wed, 16 Mar 2011 14:56:03 GMT

Michael,

thanks. What code should i use for sorting in expression?. I have used like u described in screenshot

=dim3

but its not working

thanks

Lavi

Sorting problem in pivot table

Anonymous — Wed, 16 Mar 2011 16:31:22 GMT

Lavi,
It depends on the relations beteen the dimensions, for example it will not work if there are multiple values of dim3 per dim1. It could be one of these requests that doesn't have logical solution, hence there can't be technical solution.