topic Sorting on secondary dimension in QlikView

Sorting on secondary dimension

Fri, 04 Mar 2011 07:22:29 GMT

Hi,

I have two dimension -Year and a Cyclic group(Category,Product) in a stacked bar chart and sum of Sales in expression.

I want to apply sorting on the dimensions based on the expression. It worked for first dimension alone second dimension is not getting sorted by the expression.

Please help me on this

Sorting on secondary dimension

amars — Fri, 04 Mar 2011 12:15:39 GMT

Hi ,

You can use Sort by Y-value & can keep it Sort by Ascending or desnding value..

thanks.

Sorting on secondary dimension

Fri, 04 Mar 2011 12:23:02 GMT

Thanks for ur reply. But this option is not enabled for the "Second dimension"

Sorting on secondary dimension

Fri, 04 Mar 2011 13:19:28 GMT

Hi ,

You can sort both the dimensions which you have created.

1. For the dimension Year : You can change directly from Sort Tab in the properties.

2. For the dimension Cyclic group : Chart Properties - Edit Group - Edit - SortOrder.

For Cyclic group you have option ' SORTORDER ' to sort individual dimensions used in the group.

Regards

BhargavRaj

Sorting on secondary dimension

Fri, 04 Mar 2011 13:37:48 GMT

Thanks for ur reply. I tried it already. I want to sort the cyclic group based on the expression. But it is not working as expected.

Sorting on secondary dimension

Fri, 04 Mar 2011 13:55:47 GMT

Hi, unfortunately you cannot have an individual sorting order for each group of stacked bars. 🙂 With the sorting expression that you have for your cyclic group, it will take the sum of all sales and put that category or product on the top. The sorting expression is evaluated once prior to visualization.

Sorting on secondary dimension

prieper — Fri, 04 Mar 2011 14:25:20 GMT

You *can* determine the sortorder by entering an expressions - should be ideally same as in the graph.

HTH
Peter

Sorting on secondary dimension

Fri, 04 Mar 2011 14:39:46 GMT

That's done already, if you check the attached file in the original post. The goal here is to sort each group of stacked bars separately, and that *cannot* be done in QV. 🙂

Sorting on secondary dimension

prieper — Fri, 04 Mar 2011 17:06:07 GMT

you are correct

Peter