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: 
Anonymous
Not applicable

Problem with sorting

Hello Qliks,

I look for a solution how to sort my DIM 1(Year-Month). DIMis a calculated Dimension:

=if(Year=$(vMaxYear),[Year-Month],null())DIM1.png

The final result should be:

1. Jun-2017

2. Feb-2017

3.....


Regards

Jacek.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Try

=if(Year=$(vMaxYear),Date#([Year-Month],'YYYY-MMM'),null())

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Try

=if(Year=$(vMaxYear),Date#([Year-Month],'YYYY-MMM'),null())

Anonymous
Not applicable
Author

Hello,

Thank you, it solved my problem.

Regards

Jacek.