topic Re: Single Letter Month in QlikView

Single Letter Month

nwilliams — Wed, 17 Jun 2015 14:48:02 GMT

Hi,

I'm creating a line graph to show trend, and the full axis labels are not important, so have removed them. What I am after is to get a sense of the time on the dimension axis, so want to put the month in there. The dimension I'm sowing at the moment would display "Jan 2015", but what I'm after is just "J", "F", "M" etc. I tried using "Date(field, 'M') in the load script, but the created "1", "2", "3" etc

Any ideas how I get just "J" for January?

Thanks

Re: Single Letter Month

Anonymous — Wed, 17 Jun 2015 14:50:28 GMT

=left(Month(today()),1)

Re: Single Letter Month

alexandros17 — Wed, 17 Jun 2015 14:50:37 GMT

Use:

Left(myDimension,1)

Re: Single Letter Month

ramoncova06 — Wed, 17 Jun 2015 14:50:53 GMT

You could try with a left and month combination

Left(Month(field),1 )

Re: Single Letter Month

nwilliams — Wed, 17 Jun 2015 14:56:46 GMT

Tried that, but the issue comes where you have Jan, Jun, & Jul all get grouped under one "J", same with Aug & Apr

Re: Single Letter Month

Anonymous — Wed, 17 Jun 2015 14:58:59 GMT

What single letter result are you after for each of the 12 months ?

Re: Single Letter Month

nwilliams — Wed, 17 Jun 2015 15:02:48 GMT

Jan = J

Feb = F

Mar = M

Apr = A

May = M

Jun = J

Jul = J

A = A

Sep = S

Oct = O

Nov = N

Dec = D

So when you look at a 13 month rolling chart, you would see:

M J J A S O N D J F M A M

Re: Single Letter Month

Anonymous — Wed, 17 Jun 2015 15:07:15 GMT

I am confused now as you said this was no good :

"Tried that, but the issue comes where you have Jan, Jun, & Jul all get grouped under one "J", same with Aug & Apr"

Re: Single Letter Month

awhitfield — Wed, 17 Jun 2015 15:10:25 GMT

HI Neil,

you'd need to go to for calculated dimension of =Left(Month,3) to get them unique

HTH

Andy

Re: Single Letter Month

ramoncova06 — Wed, 17 Jun 2015 15:11:38 GMT

maybe by using a dual function so each entry is recognized as a different value

=dual(Left(Month(field),1 ),num(month(field)))

Re: Single Letter Month

nwilliams — Wed, 17 Jun 2015 15:14:34 GMT

in my load script for my calendar, I have put the following:

Left(Month(c_Date),1) AS Calendar.MonthInital,

When I use "Calendar.MonthInital" as a dimension, in Stead of 13 months I get 8, in a random order. Currently "N,D,J,O,S,A,M,F"

My suspicion is as "J" is not unique, it puts all of Jan, Jun & Jul under "J"

Re: Single Letter Month

antoniotiman — Wed, 17 Jun 2015 15:19:11 GMT

I think Ramon answer is correct.

However You can' change dimension and chek

But You have J...F..M. and so on.

Regards,

Antonio

Re: Single Letter Month

nwilliams — Wed, 17 Jun 2015 15:22:45 GMT

This has done it, but to get this work over 2 years instead on using month number as the second part, I changed it to Month Name

Dual(Left(Month(c_Date),1 ),MonthName(c_Date))

Thanks!!!!! ::)