Problem with sorting

[Anonymous]

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())

The final result should be:

1. Jun-2017

2. Feb-2017

3.....

Regards

Jacek.

[MK_QSL · Accepted solution]

Try

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

[Anonymous]

Hello,

Thank you, it solved my problem.

Regards

Jacek.