topic Re: macro in QlikView

macro

Sat, 08 Dec 2012 14:04:52 GMT

Hi Community,

I need help in macro.

I have requirement in Qlikview app. That is assume that we have 3 sheets. If i made selections in sheet 3 then it will reflect in every sheet normally. But when I come to sheet 2 it should clear my selections. At the same time again if go back to sheet 3, the selections still need to remain.

If i use trigger then it wont fulfil my need. Because it clears all sheets. So i heard its possible by macro.

Can you help me out.

Thanks in advance.

Regards

Suneela

Re: macro

Gysbert_Wassenaar — Sat, 08 Dec 2012 15:37:40 GMT

You can also use the OnLeaveSheet trigger to first set a bookmark before leaving the sheet 3. You can later restore that bookmark when you get back to the sheet 3 with the OnActivateSheet trigger.

An alternative if you have Qlikview 11 is to create an alternate state and assign that state to sheet 2. That way sheet 2 will use its own set of selections and ignore those set on other sheets.

Re: macro

Sat, 08 Dec 2012 17:27:18 GMT

Can you make it out in attached file.

Thanks.

Re: macro

Gysbert_Wassenaar — Sat, 08 Dec 2012 17:55:24 GMT

See attached file. Sheets Main and Savings have bookmarks that they set on leaving and restore on entering. Sheet Salary clears all selections on entering.

Re: macro

Sat, 08 Dec 2012 18:08:08 GMT

Thanks Gysbert. It really helped me.