Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

Sorting a calculated dimension

I have the below columns in a pivot table from a single calculated dimension.

2Q 2016

3Q 2016

4Q 2016

1Q 2017

How do I sort them to be in above sequence? I get the below result when using =Only({1} Dim) in Sort tab => Expression

1Q 2017

2Q 2016

3Q 2016

4Q 2016

4 Replies
prat1507
Specialist
Specialist

Hi use in expression

right(Dim,4)*1000+left(Dim,1)

and sort in Ascending order

Regards
Pratyush

krishnacbe
Partner - Specialist III
Partner - Specialist III

If you have a Date column, you an use that in sort expression and sort in Ascending Order

sunny_talwar

Do you have a date field? May be this

Max({1} Date)

newqlik2017
Creator II
Creator II
Author

That worked, Sunny. Thank you.