Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Months Order

I have a data model with Month and Amount As Fields

Month          Amount

Jan               2000

Feb               4000

Mar                3000

etc

when I select a month my output should be from selected month and 12 month back word. That is if I select May report should be like one given below

May  Apr  Mar   Feb  Jan  Dec  Nov  Oct  Sep   Aug  Jul  Jun

Pls help me

1 Reply
vijetas42
Specialist
Specialist

Hi,

In sort tab check expression and in that expression type your month field name and also check load order and keep it original

Hope this will help you

Regards,

Vijeta