topic Re: Hidden Objects in QlikView

Hidden Objects

Wed, 25 Jun 2014 20:31:44 GMT

I am developing an Qlikview Application and I want the information about all the sheets and objects that are hidden or not.

Is there a way to achieve this ?

Problem arises in using Objects = ss.GetSheetObjects and when I try to extract information from different objects on the sheet i.e copy bitmap to clipboard etc. In the case of the hidden objects it constantly copies the last unhidden objects image to clipboard.

I am using vbscript.

Re: Hidden Objects

Wed, 25 Jun 2014 22:18:52 GMT

Hii,

I am not sure what you actually want to know.

But as per my understanding you can refer Setting/Document Property/Sheets tab.

It will give you all the information regarding Sheets, Objects which are active and hidden.

Thanks & Regards

Greg

Re: Hidden Objects

nilo_pontes — Wed, 25 Jun 2014 22:31:43 GMT

Hi Lokesh,

Maybe Crtl + Alt + E (Expression Overview) helps you.

There's a 'show conditions' option for hidden objects.

Regards

Re: Hidden Objects

Anonymous — Thu, 26 Jun 2014 02:45:26 GMT

Hi,

Press Ctrl+Alt+D, Go to Sheets tab and you can see all hidden sheets and objects (see below). Or if you want to see all hidden objects then simply press Ctrl+Shift+S.

Re: Hidden Objects

vardhancse — Thu, 26 Jun 2014 09:19:25 GMT

Yes what are all the objects in the sheet can be seen in Sheet Properties->Shets