topic Re: Current Year and Month selection in QlikView

Current Year and Month selection

siva0606 — Mon, 25 Feb 2013 07:15:49 GMT

I am having two list boxes Year and month in Aging sheet. Always Current year and Current Month should get selected.

For example, Year field has 2009,2010 and 2011,then 2011 should always get selected.

If Year updated to 2009,2010,2011 and 2012, then 2012 should always get selected.

Same for month.

FYI: Only for Aging sheet, Current Year and Current Month selection should work.

If we click the other sheets ,this Current Year and Current Month selection should not get selected.

I am new to Macros.Please give me a clear explanation.

sushil353 — Mon, 25 Feb 2013 07:25:48 GMT

hi,

PFA

I have added trigger on sheet level.

Check trigger in

Settings>sheet level properties>trigger

HTH

Sushil

siva0606 — Mon, 25 Feb 2013 11:36:59 GMT

Thanks

sushil353 — Mon, 25 Feb 2013 11:39:59 GMT

Hi Siva,

if your problem is resolved then please close this thread marking this as answered.

HTH

Sushil

Mon, 25 Feb 2013 14:36:37 GMT

I am using the same thing in version 11 but it is good gor year but when i select it for month the changes are being made in two sheets