topic Re: month order in QlikView

month order

master_student — Mon, 20 Feb 2017 10:00:42 GMT

Hello Guys,

As you can see bellow, my graph is not sorted

my expression is month(date_calcul) & year(date_calcul)

Any idea, how to solve this?

Thanks

Anil_Babu_Samineni — Mon, 20 Feb 2017 10:09:08 GMT

Use Quite Date Function

MonthName(DateField) as MonthName1

Date(DateField,'MMM YYYY') as MonthName1

Then use MonthName1 as Dimension / You can use same for dim which can be done Calculation

Then go to sort and apply as per your needs

vinieme12 — Mon, 20 Feb 2017 10:43:08 GMT

Try "Sort by expression"

NUM#(DATE(date_calcul,'YYYYMM'))