topic Re: MonthName function in QlikView

MonthName function

Mon, 26 Oct 2015 13:24:43 GMT

Hi Team,

I have a csv data source containing Date column in the format 'DD-MMM-YY eg: 22-Oct-15.

I want to display this dates in the format MMM-YYYY in multibox.

I tries this by using MonthName() function but couldn't find any solution.

Please help me out. Attached is the csv for your reference.

Thanks in advance

Regards

Priyanka

Re: MonthName function

Anonymous — Mon, 26 Oct 2015 13:30:15 GMT

just use function date

date(yourdatefield,'MMM-YYYY')

Re: MonthName function

Mon, 26 Oct 2015 13:32:24 GMT

Hi,

I tried using this but couldn't find the exact solution.

I am not getting any item in the list box.

Regards

Priyanka

Re: MonthName function

Anonymous — Mon, 26 Oct 2015 13:41:02 GMT

use expression in multibox

Re: MonthName function

sunny_talwar — Mon, 26 Oct 2015 13:48:16 GMT

See if this helps:

SET DateFormat='D-MMM-YY';

Table:

LOAD [Planned Completion Date],

[Revised Completion Date],

MonthName([Planned Completion Date]) as Test1,

MonthName([Revised Completion Date]) as Test2,

Date([Planned Completion Date], 'MMM-YYYY') as Test3,

Date([Revised Completion Date], 'MMM-YYYY') as Test4

FROM

export.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: MonthName function

MK_QSL — Mon, 26 Oct 2015 13:51:50 GMT

Use below as an expression in MultiBox or ListBox

Date(Date#([Planned Completion Date],'DD-MMM-YY'),'MMM-YYYY')

Re: MonthName function

narband2778 — Mon, 26 Oct 2015 13:54:34 GMT

Hi Manish,

Why are you using Date# function in your expression.

As planned completion date field is number format.

Is there any specific reason to use Date#.........

Thanks,

Naresh

Re: MonthName function

krishna20 — Mon, 26 Oct 2015 14:02:31 GMT

Hi Naresh,

Refer the below link.you will get an idea.

The Date Function

Re: MonthName function

Mon, 26 Oct 2015 14:23:29 GMT

Hi,

I tries using the above expression but it didn't work in my case.

I am getting a empty multibox

Re: MonthName function

narband2778 — Mon, 26 Oct 2015 14:24:56 GMT

Got it.

Thanks Krishna

KR,

Naresh

Re: MonthName function

sunny_talwar — Mon, 26 Oct 2015 14:30:40 GMT

Did you look at the script I provided above? May be that helps?

Re: MonthName function

sasikanth — Tue, 27 Oct 2015 11:11:18 GMT

HI,

Try something like this,

Date(date#([Revised Completion Date],'DD-MMM-YY'),'MMM-YYYY') as MonthAndYear

Re: MonthName function

vishsaggi — Tue, 27 Oct 2015 11:26:21 GMT

Hello Priyanka,

Did you try using Sunny's script or qvw file he sent??

Can you send us your qvw file where you cant see the dates in Multibox here.

Thanks,
V.

Re: MonthName function

rwunderlich — Tue, 27 Oct 2015 12:09:48 GMT

Rudolf,

I would think your solution would work. But I suggest adding MonthStart() to generate only one row per MMM-YYYY value.

=date(MonthStart(yourdatefield),'MMM-YYYY')

-Rob

Re: MonthName function

Tue, 27 Oct 2015 12:55:48 GMT

Hi,

I tried you script and its dosent work for me.

belowis the screenshot for your reference.

Re: MonthName function

sasikanth — Tue, 27 Oct 2015 13:01:30 GMT

HI ,

please find the attached applicaiton

Re: MonthName function

swuehl — Tue, 27 Oct 2015 13:02:15 GMT

That's because your Date field values are not read in as dates (i.e. intepreted as dates by QV and having a numeric representation).

Your date format seems to be 'DD/MMM/YY' instead of 'DD-MMM-YY'.

Try to adapt your code with the correct input value format.

SET DateFormat = 'DD/MMM/YY';

Note that two digit year format is ambiguous, might lead to some 'wrong' 4 digit year values when QV tries to intepret these values.

edit:

Re: MonthName function

Tue, 27 Oct 2015 13:11:48 GMT

Hi,

Thank you very much.

It solved my problem

Thanks once again

Regards

Priyanka

Re: MonthName function

vishsaggi — Tue, 27 Oct 2015 13:31:18 GMT

Hey Priyanka,

Can you close the thread by marking as Helpful or Answered if it resolved your issue.

Many thanks,