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

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

paulyeo11 — Mon, 04 Jul 2016 13:39:08 GMT

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

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

MK_QSL — Mon, 04 Jul 2016 13:45:56 GMT

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

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

MK_QSL — Mon, 04 Jul 2016 13:49:35 GMT

Use something like below...

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

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

paulyeo11 — Mon, 04 Jul 2016 14:00:09 GMT

Wow you are very good., it work again.