Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Specialist
Specialist

Re: Sorting a calculated dimension

Hi use in expression

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

and sort in Ascending order

Regards
Pratyush

Highlighted
Partner
Partner

Re: Sorting a calculated dimension

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

Highlighted

Re: Sorting a calculated dimension

Do you have a date field? May be this

Max({1} Date)

Highlighted
Creator
Creator

Re: Sorting a calculated dimension

That worked, Sunny. Thank you.