How to get month Jan wiae - Page 2 - Qlik Community

Report Inappropriate Content · ‎2016-12-09

Hi Friends,

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

arasantorule · ‎2016-12-09

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 · ‎2016-12-09

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 · ‎2016-12-09

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 · ‎2016-12-09

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.