Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

how to order alternative dimensions?

Hi,

I do have a simple bar chart that is aggregating data by week and is also ordering by week.

weeks.jpg

If I switch to the alternative dimension month, it is showing data in incorrect order.

months.jpg

I have not found a way to define how data should be ordered for alternative dimensions. Can you help?

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: how to order alternative dimensions?

Select Dimensions one by one and then choose sorting for them.

7 Replies
awhitfield
Esteemed Contributor

Re: how to order alternative dimensions?

Hi Malik,

any chance that you could upload a sample .qvf?

Andy

shraddha_g
Honored Contributor III

Re: how to order alternative dimensions?

In Sorting section,  there will be a dropdown of alternative dimension . . Select each dimension and sort in appropriate order

Not applicable

Re: how to order alternative dimensions?

Unfortunately, I'm not allowed to share the data but I will try to create a demo app of the issue with dummy data

Not applicable

Re: how to order alternative dimensions?

That's not correct. I know it is possible if you show multiple dimensions at once but in case of alternative dimensions it's not showing additional dimension. I only see the default dimension and the default measure:

order_settings.png

shraddha_g
Honored Contributor III

Re: how to order alternative dimensions?

Select Dimensions one by one and then choose sorting for them.

Not applicable

Re: how to order alternative dimensions?

Not a very intuitive solution from Qlik but it indeed worked. Thanks a lot!

amien
Valued Contributor

Re: how to order alternative dimensions?

it's really bad indeed, specially when you have 30 alternative measures

Community Browser