Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

MonthName function

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

18 Replies
Anonymous
Not applicable
Author

just use function date

date(yourdatefield,'MMM-YYYY')

Not applicable
Author

Hi,

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

I am not getting any item in the list box.

Regards

Priyanka

Anonymous
Not applicable
Author

use expression in multibox

sunny_talwar

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


Capture.PNG

MK_QSL
MVP
MVP

Use below as an expression in MultiBox or ListBox

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

narband2778
Creator II
Creator II

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

krishna20
Specialist II
Specialist II

Hi Naresh,

Refer the below link.you will get an idea.

The Date Function

Not applicable
Author

Hi,

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

I am getting a empty multibox

narband2778
Creator II
Creator II

Got it.

Thanks Krishna

KR,

Naresh