Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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