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: 
manozpph
Creator
Creator

How to get months names along with years in slider object box...?

Guys, can you help me to get month names in slider object like Jan,Feb,mar.....,along with years in slider.

I took year as field in slider and tried to apply month names as variable but,month names not showing in variable box under year field.

I got months in number format and not in text format.Here I want text format  appearing  with years.

Thanks in Advance.....!

4 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.

Script:

Data:

LOAD Date(Date) AS Date,

MonthName(Date) AS MonthName

INLINE [  

    Date

    1/1/2014

    2/1/2014

    3/1/2014

    4/1/2014

    5/1/2014

    6/1/2014

    7/1/2014

    8/1/2014

    9/1/2014   

];

Now use MonthName as field in Slider object.

Regards,

Jagan.

sujeetsingh
Master III
Master III

You can use concatenated field with month and year too.

ashfaq_haseeb
Champion III
Champion III

Hi

use below

MonthName(YourDate) as YearMonth,

Regards

ASHFAQ

johncahillhp
Contributor III
Contributor III

My dates are in number format as well.

I use the Slider Object Properties Number settings.

- Override the Document Settings

- Select Date

- Change the Format Pattern to MMM-yyyy

John