Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get month Jan wiae

Hi Friends,

How to get months (Jan ,feb....................................dec) wise please help me i am getting april ,may like that

13 Replies
arasantorule
Creator III
Creator III

Hi,

I understand that, you require the chart to be sorted by monthly.

If so, please try using num(Month) in sort tab (by expression).

Thanks.

Anil_Babu_Samineni

You want this from Script / Front End?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Hi Siva,

Write following expression in your edit script

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

And for getting month name like Jan, Feb..... use following in your edit script:

Date(DteFiled,'MMM') AS MonthName

From above you will get MonthName as field which has extracted month names from your date field.

Thanks,

dineshm030
Creator III
Creator III

Hi,

Below is doc for your reference.

Go Sort tab and Un-Mark the Text Tick Box and Mark the Load Order and Set the ORIGINAL.

Capture.PNG

Capture1.PNG