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: 
paulwalker
Creator II
Creator II

Need Help

Hi Community,

I have one issue in Expression Label..

In my bar chart comparing Current month and Previous Month data.

in label i have used Max(Month) but it showing Number... I want to show Month name..

based on selection i want to change...

Thanks in advance..............

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi,

like the below snapshot.

Capture1111.JPG

PFA.

View solution in original post

14 Replies
settu_periasamy
Master III
Master III

Try,

=MonthName(Max(Month))

paulwalker
Creator II
Creator II
Author

Hi Settu,

Thanks for response...

it's showing jan 1900

paulwalker
Creator II
Creator II
Author

Hi All,

=If(Max(Month)=12, 'Dec',

     If(Max(Month)=11, 'Nov',  and so on......

This expression works fine............

any other solution..????

settu_periasamy
Master III
Master III

Sorry,

Try this,

Month(Max(Month))

PrashantSangle

Hi,

if you have to different field for month and year then try

max(Month) &' '& max(Year)

or create a monthyear field in script level and use it in your front end.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
maxgro
MVP
MVP

left(MonthName(Max(Month)),3)


date(Max(Month),'MMM')



Anonymous
Not applicable

Hi Paul ,

Check your default monthname settings .

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Thanks

Not applicable

Hi Paul,

Try like this way:

Date(Max(Month), 'MMM')

Ramya.


paulwalker
Creator II
Creator II
Author

HI All,

Thanks for reply everyone..

In expression label i want to show Month name and previous month name

PFA,