Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

month order

Hello Guys,

As you can see bellow, my graph is not sorted

Capture.PNG

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

Any idea, how to solve this?

Thanks

2 Replies
Anil_Babu_Samineni

Use Quite Date Function

MonthName(DateField) as MonthName1

OR

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion II
Champion II

Try "Sort by expression"

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