topic Re: How to get month Jan wiae in QlikView

How to get month Jan wiae

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

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

Re: How to get month Jan wiae

tresB — Fri, 09 Dec 2016 05:29:50 GMT

In the script, set your month convention like:

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

Re: How to get month Jan wiae

dineshm030 — Fri, 09 Dec 2016 05:50:56 GMT

Hi,

Do u want like this??

Re: How to get month Jan wiae

susovan — Fri, 09 Dec 2016 06:14:58 GMT

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

];

Re: How to get month Jan wiae

Fri, 09 Dec 2016 06:42:01 GMT

yes

Re: How to get month Jan wiae

Fri, 09 Dec 2016 06:47:13 GMT

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

Re: How to get month Jan wiae

tresB — Fri, 09 Dec 2016 07:09:53 GMT

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?

Re: How to get month Jan wiae

Fri, 09 Dec 2016 07:13:21 GMT

Hi ,

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

Re: How to get month Jan wiae

dineshm030 — Fri, 09 Dec 2016 07:21:59 GMT

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';

Re: How to get month Jan wiae

Fri, 09 Dec 2016 07:27:54 GMT

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

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.

Re: How to get month Jan wiae

arasantorule — Fri, 09 Dec 2016 07:28:18 GMT

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.

Re: How to get month Jan wiae

Anil_Babu_Samineni — Fri, 09 Dec 2016 07:34:47 GMT

You want this from Script / Front End?

Re: How to get month Jan wiae

Anonymous — Fri, 09 Dec 2016 09:21:19 GMT

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,

Re: How to get month Jan wiae

dineshm030 — Fri, 09 Dec 2016 12:00:39 GMT

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.