topic Re: Getting monthname from composite key in QlikView

Getting monthname from composite key

rsdhavle — Thu, 06 Feb 2014 12:46:14 GMT

I have one composite key of year and month having values like 201112, 201111,201203..

I want to calculate monthname from this values. How can i get that?

Re: Getting monthname from composite key

puttemans — Thu, 06 Feb 2014 12:57:23 GMT

'right(composite key,2) as Month' will give you the last 2 digits of your key, and recode it as month.

Re: Getting monthname from composite key

Peter_Cammaert — Thu, 06 Feb 2014 13:02:42 GMT

Use

Date(Date#(CompositeKey&'01', 'YYYYMMDD'), 'MMMM')

for the full month name.

Peter

Edit: Sorry, correct now

Re: Getting monthname from composite key

Thu, 06 Feb 2014 13:03:25 GMT

Hi,

You can try this,

Date#(month(date#(right('201203',2),'MM'))&'-'&Year(date#(left('201203',4),'YYYY')),'MMM-YYYY')

HTH

-Shruti

Re: Getting monthname from composite key

ashwanin — Thu, 06 Feb 2014 13:03:47 GMT

Month(Fiedl) as Month

Re: Getting monthname from composite key

ashwanin — Thu, 06 Feb 2014 13:12:44 GMT

and if you want to display the Year also then

Month(Field)&'-'&lEFT(Field,4) as DATE_YEAR

Re: Getting monthname from composite key

rsdhavle — Thu, 06 Feb 2014 13:14:56 GMT

Shruti,

When i pass yearmonth that is my fieldname instead of 201203 this expression is not working

Re: Getting monthname from composite key

Thu, 06 Feb 2014 13:23:41 GMT

Hi,

When using field no qoutes required.

As per my knowledge this works on field too.

I will check on dummy field and get back.

-shruti

Re: Getting monthname from composite key

puttemans — Thu, 06 Feb 2014 13:25:26 GMT

If you put = right(yearmonth,2) in your dimension of the chart (first add yearmonth, and then click 'edit', and you enter the expression, then the chart will show you the months.

Re: Getting monthname from composite key

Thu, 06 Feb 2014 13:29:27 GMT

Hi,

Check this code,

LOAD * INLINE [
       F1
    201304
    201405
    201212
];

Load Date#(month(date#(right(F1,2),'MM'))&'-'&Year(date#(left(F1,4),'YYYY')),'MMM-YYYY') as month
Resident
test;

it gives me data like

Dec-2012

Apr-2013

May-2014

If still facing issues, attach some sample.

HTH

-Shruti

Re: Getting monthname from composite key

rsdhavle — Mon, 10 Feb 2014 12:20:37 GMT

Thanks Shruti. It worked