Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Master III
Partner - Master III

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

View solution in original post

7 Replies
awhitfield
Partner - Champion
Partner - Champion

Hi Malik,

any chance that you could upload a sample .qvf?

Andy

shraddha_g
Partner - Master III
Partner - Master III

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

Not applicable
Author

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
Author

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
Partner - Master III
Partner - Master III

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

Not applicable
Author

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

amien
Specialist
Specialist

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