topic Is Sheet deactivate possible in QlikView ? in QlikView

Is Sheet deactivate possible in QlikView ?

montubhardwaj — Thu, 02 Sep 2010 07:00:19 GMT

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

Is Sheet deactivate possible in QlikView ?

raghavsurya — Thu, 02 Sep 2010 08:06:21 GMT

hi,

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

Thanks and Regards,

Raghav

Is Sheet deactivate possible in QlikView ?

sunil2288 — Thu, 02 Sep 2010 09:53:42 GMT

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

Is Sheet deactivate possible in QlikView ?

montubhardwaj — Thu, 02 Sep 2010 10:05:26 GMT

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

Is Sheet deactivate possible in QlikView ?

montubhardwaj — Thu, 02 Sep 2010 10:07:55 GMT

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

Is Sheet deactivate possible in QlikView ?

sunil2288 — Thu, 02 Sep 2010 10:10:30 GMT

Hi Sharma

Then u should prefer for writing Macro ...

Regards

sunil

Is Sheet deactivate possible in QlikView ?

montubhardwaj — Thu, 02 Sep 2010 10:29:44 GMT

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

Is Sheet deactivate possible in QlikView ?

montubhardwaj — Thu, 02 Sep 2010 10:31:43 GMT

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