Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stefan_fischer
New Contributor II

Dynamic Month-Listbox

Hello,

in a month listbox should be indicated month and year. This is controlled on two additional boxes. If year 2014 is selected, the month listbox should begin with Oct 14 and ends in the Sep 15. 2015 begins in Oct 15 and ends Sep 16. With the second FiscalYear-Listbox the months should be able to be changed in the same way.

Regards Stefan

3 Replies
jpenuliar
Valued Contributor III

Re: Dynamic Month-Listbox

Hi Stefan,

Lee Mathews has a good example how to integrate Fiscal Year in his calendar(offset)

http://community.qlik.com/docs/DOC-5486

stefan_fischer
New Contributor II

Re: Dynamic Month-Listbox

Thank for your reply. Fiscal year is integrate in my script. But I would like to change month-box in dependence of the year.

jpenuliar
Valued Contributor III

Re: Dynamic Month-Listbox

Looking at your Data Model, you already have a "mon_YY" field.

You can use this in your listbox instead of "mon" field

Community Browser