topic Re: Sorting in Pivot Table in QlikView

Sorting in Pivot Table

Mon, 20 Apr 2009 23:26:18 GMT

Please , Can anybody sort this Pivot table.

I need to Sort the First Dimension by A->Z

Second dimension by the 'Y' Axis or the expression column in the pivot table,

Sorting in Pivot Table

Tue, 21 Apr 2009 00:07:04 GMT

Normal 0

Should be able to right hand click on the pivot table select "properties" then go to the sort tab. It allows you to sort the dimensions and the expressions. If you want to sort by expression, make sure to check "expression" then put in Sum("sum([01])"+"sum([02])")

Let me know how it works out.

Sorting in Pivot Table

Tue, 21 Apr 2009 02:38:21 GMT

I tried this, it doesnt work.

Because the expression used in the sort options are not calculated based on the first dimension. It calculates irrespective of what ever is in the first dimension.

Sorting in Pivot Table

Wed, 22 Apr 2009 00:58:33 GMT

Can anybody solve this sorting issue.

Sorting in Pivot Table

Wed, 22 Apr 2009 05:40:26 GMT

Ok, I haven't tested this and this may be a long way around but you could try this.

In your edit script add this mid(MMIR_GEO_NAME,11,5) AS MMIR_GEO_NAME_NEW

Add a table name to the top of your load statement

Table1:

Load

Then load all your fields in a resident table and do an order by statement. Then in your pivot table sort by your expression..

Like I said untested but this my help.

Sorting in Pivot Table

Mon, 16 Aug 2010 03:33:06 GMT

did anyone manage to find a solution to this? it's making me consider another BI tool or go back to Excel...

Re: Sorting in Pivot Table

Fri, 20 Sep 2013 18:46:50 GMT

FYI: three years later, it remains broken in QlikView 11.

Re: Sorting in Pivot Table

Anonymous — Fri, 20 Sep 2013 21:35:57 GMT

If you just pretend Pivot Tables don't exist in QlikView it becomes a much better tool. The pivot table is a crude short cut to something that could be much more visually appealing and more productive using QlikView.

Re: Sorting in Pivot Table

Fri, 20 Sep 2013 21:54:28 GMT

Ha! I appreciate your candor. The problem of course is that when you need a crosstab, you need a crosstab. I can sometimes work around these limits with elaborate expressions: "Sum(IIf(Dimension = X, Metric, 0))" in one column, "Sum(IIf(Dimension = Y, Metric, 0))" in the next, for example. What really makes me cringe is trying to explain this to semi-technical business users. I'm trying to sell them on a new tool, but every other sentence is "now the catch here is...". Painful.