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: 
paulyeo11
Master
Master

Label expression NO display Jan - Dec when user click month = 12

Hi All

Below is my Expression label work fine :-

='Jan -  ' & date(makedate(max(year)-0,max({<Year={$(=max(year)-0)}, sales = {'*'}>} Month)), 'MMM-YYYY') & ' ' & ''  &ColumnDim51& ' ' 

Recently MrManish help me to modify the expression , allow user to view sales till Dec. when use click on month=12 yr=2016 , the label display not correct.

Hope some one can share with me.

Paul

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Use something like below...

='Jan - '&SubField('$(MonthNames)', ';',  $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today())))))

View solution in original post

3 Replies
MK_QSL
MVP
MVP

What is the requirement? Unable to understand from your question..

MK_QSL
MVP
MVP

Use something like below...

='Jan - '&SubField('$(MonthNames)', ';',  $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today())))))

paulyeo11
Master
Master
Author

Wow you are very good., it work again.