Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
MVP
MVP

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

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