topic Re: Dynamic Month-Listbox in QlikView

Dynamic Month-Listbox

Anonymous — Mon, 02 Mar 2015 08:54:06 GMT

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

Re: Dynamic Month-Listbox

jpenuliar — Mon, 02 Mar 2015 09:04:47 GMT

Hi Stefan,

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

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

Re: Dynamic Month-Listbox

Anonymous — Mon, 02 Mar 2015 10:30:18 GMT

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

Re: Dynamic Month-Listbox

jpenuliar — Mon, 02 Mar 2015 11:26:48 GMT

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

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