Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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.
maxgro
MVP
MVP

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


date(Max(Month),'MMM')



rgvavihs
Specialist
Specialist

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,