Solved: Is Sheet deactivate possible in QlikView ? - Qlik Community

montubhardwaj · ‎2010-09-02

Hi Community,

I have a application in which I have 6 sheets with certain number of objects in each sheet. I want to have functionality like if I select anything in a sheet (say sheet 6) that should not reflect in any other sheet(sheet 1- sheet 5). Also If I select anything in other sheets, that should not reflect in sheet 6 alone. In short, can I separeate sheet 6 from other sheets ?

Many thanks in advance.

Regards,

Sharma

montubhardwaj · ‎2010-09-02

Hi Guys,

I think I figured it out. It was simple enough. I just wrote a Macro something like this:

sub Selection
ActiveDocument.ClearAll False

end sub

Then I applied this Macro to Sheet 6 for both "OnActivateSheet" and also "OnLeaveSheet" and is workin perfectly now.

Thanks for your answers/suggestions.

Cheers,

Sharma

View solution in original post

raghavsurya · ‎2010-09-02

hi,

Check using the condition in General Tab of Sheet properties. Other option is to use a Macro.

Thanks and Regards,

Raghav

sunil2288 · ‎2010-09-02

HI Sharma,

In settings go to Sheet Properties,There you go to security,

There you can find a checkbox readonly..Just click on that it will keep the sheet as read only.

Hope it will help solve your problem..

Regards

Sunil

montubhardwaj · ‎2010-09-02

Hi Raghav,

I dont want to Hide the entire sheet at all. So the Condition in the General tab of sheet properties will not be helpful(I think). May be I need to try using Macros.

Thanks for giving it a shot.

Cheers,

Sharma

montubhardwaj · ‎2010-09-02

Hi Sunil,

I should be able to make Selections in Sheet 6. But if you check "Read Only", you won't be able to make any selections too.

Cheers,

Sharma

sunil2288 · ‎2010-09-02

Hi Sharma

Then u should prefer for writing Macro ...

Regards

sunil

montubhardwaj · ‎2010-09-02

Hi Guys,

I think I figured it out. It was simple enough. I just wrote a Macro something like this:

sub

Selection

ActiveDocument.ClearAll False

end

Then I applied this Macro to Sheet 6 for both "OnActivateSheet" and also "OnLeaveSheet" and is workin perfectly now.

Thanks for your answers/suggestions.

Cheers,

Sharma

montubhardwaj · ‎2010-09-02

Hi Guys,

I think I figured it out. It was simple enough. I just wrote a Macro something like this:

sub Selection
ActiveDocument.ClearAll False

end sub

Then I applied this Macro to Sheet 6 for both "OnActivateSheet" and also "OnLeaveSheet" and is workin perfectly now.

Thanks for your answers/suggestions.

Cheers,

Sharma