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

Not select month and year can it display jan - mar 2016 ?

Hi All

I have below expression , it will display Jan to Mar 2016 when i click on year = 2016 and month =3 :-

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

May i know how to change it , when user not click on year and month , how to make it display Jan  to Mar 2016

Now it display Jan - Dec 2016 is wrong.

Paul

6 Replies

Re: Not select month and year can it display jan - mar 2016 ?

This:

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

paulyeo11
Valued Contributor II

Re: Not select month and year can it display jan - mar 2016 ?

Hi sunny

Beautiful it work fine.

Thank

Paul

paulyeo11
Valued Contributor II

Re: Not select month and year can it display jan - mar 2016 ?

Hi sunny

why i cannot mark as correct answer ? only can mark as helpful ?

Paul

Re: Not select month and year can it display jan - mar 2016 ?

Because this thread is a discussion thread and not a question thread. It can only be changed within the first 15 minutes from a discussion to question or question to discussion. I don't think you can change it now

paulyeo11
Valued Contributor II

Re: Not select month and year can it display jan - mar 2016 ?

Hi sunny

i just notice that there it discussion and question. okay next time i take note , make sure it is question .

Paul

Re: Not select month and year can it display jan - mar 2016 ?

No problem

Community Browser