Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.