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
tresesco
MVP
MVP

In the script, set your month convention like:

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

dineshm030
Creator III
Creator III

Hi,

Do u want like this??

Capture.PNG

susovan
Partner - Specialist
Partner - Specialist

You can also try this script,

Month:

LOAD * INLINE [

Sl.No,Month

1,Jan

2,Feb

3,Mar

4,Apr

5,May

6,Jun

7,Jul

8,Aug

9,Sep

10,Oct

11,Nov

12,Dec

];

Warm Regards,
Susovan
Not applicable
Author

yes

Not applicable
Author

Hi ,

here my requirement is i want take month s start 's from January

I have Date field Gldate(12-05-2014) format is ('DD-MMM-YYYY')

i HAVE EXTRACT MONTH YEAR(Gldate) AS YR

AND MONTH AS MONTH(Gldate) .

In UI Part I want Start's it from Jan ,Feb,Mar

tresesco
MVP
MVP

If it is starting from April, that means your date field creation probably has been done considering the Fiscal Year. if you want to fix it in the UI, you can, however, it would be a better idea to fix it in the script itself. Could you post your calendar creation script or may be a sample qvw that demonstrates the issue?

Not applicable
Author

Hi ,

I am Getting Error while Open another QVW files Could you Suggest me how to open other QVW file.

dineshm030
Creator III
Creator III

Then go to script page and set the variable like this:

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

Not applicable
Author

Follow the following steps and if you find it right.. mark as correct answer.

Untitled.png

To change the order from (jan to dec) like second chart... go to chart properties and sort tab and follow the belows step and click ok. Thats it.

Untitled1.png