Month-Year is not getting in Proper order

[Kohli]

I date field. From that date field , I have created MMM-YYYY field with function 

Month(DATE)&'-'&Year(DATE)AS  Month_Year.

Iam getting month OCT-2017, Nov-2018, Oct-2018

I need OCT-2017, OCT-2018, Non-2018.   

[dx_anupam]

Hi ,

I think you are using qliksense ,and created a custom dimension with formula

Month(DATE)&'-'&Year(DATE).

Once you are done with the visualization you can apply sorting based on sort numerically.

it will fix the issue.

[Kohli]

No, It not Solving.. i am already selected that only.

[pradosh_thakur]

sort by expression
right(Month_Year,4)

[PrashantSangle · Accepted solution]

Hi,

To evaluate month year from date you can use
MonthName() or Date(dateField,'MMM-YYYY')

Use above 2 functions and try.

Regards,
Prashant Sangle

[Kohli]

Thanks a lot. It's absolutely working fine..