Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva0606
Contributor III
Contributor III

Current Year and Month selection

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.

4 Replies
sushil353
Master II
Master II

hi,

PFA

I have added trigger on sheet level.

Check trigger in

Settings>sheet level properties>trigger

HTH

Sushil

siva0606
Contributor III
Contributor III
Author

Thanks

sushil353
Master II
Master II

Hi Siva,

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

HTH

Sushil

Not applicable

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