Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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
MVP
MVP

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

Use something like below...

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

3 Replies
MVP
MVP

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

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

MVP
MVP

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

Use something like below...

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

paulyeo11
Valued Contributor II

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

Wow you are very good., it work again.

Community Browser