topic Sheet Restrtiction(URGENT) in QlikView

Sheet Restrtiction(URGENT)

Wed, 29 Jul 2009 11:23:48 GMT

How we can restrict the sheet of viewing? i Have seen the Show Sheet tab?How can I apply the condition

over there.. what will be the conditions.......any example will be very greatfull...

Regards

Sikandar

Sheet Restrtiction(URGENT)

rwunderlich — Wed, 29 Jul 2009 13:28:16 GMT

I believe a common method is to define a Sheet Show condition that tests the qvuser() value.

-Rob

Sheet Restrtiction(URGENT)

Wed, 29 Jul 2009 13:56:42 GMT

You may have any condition you wish to show the sheet...it could also be based on selection of a value from a list box or on QVUser() as mentioned by Rob. However QVUser() works with section access. If you dont have section access, you may use OSUser(). An example condition is

=OSUser() = 'domain\username'

Thanks

Amit

Sheet Restrtiction(URGENT)

Wed, 29 Jul 2009 15:40:22 GMT

Thank You soo much Amit and Rob. i was able to acheive it through Section Access..

Regards

Sikandar

Sheet Restrtiction(URGENT)

Wed, 29 Jul 2009 16:34:40 GMT

You can also achive this through the conditional show of the sheets.

Sheet Restrtiction(URGENT)

Wed, 29 Jul 2009 16:52:04 GMT

I ve got a lot of sheets in my analizies. There are 4 groups of these sheet dependent on who need these analyzies from Analyzer level. I add the initial sheet. Then i put 4 buttons and write a macros which hide and show adequate sheets.

<code>

Sub show
set y = ActiveDocument.Variables("Marketing")
y.SetContent "0", true
end sub

sub market
set y = ActiveDocument.Variables("Marketing")
if y.GetContent.String="1" then
ActiveDocument.Variables("Marketing").SetContent "0",true
set button1 = ActiveDocument.getsheetobject("BU63")
set prop = button1.GetProperties
prop.Text.v = "Pokaz analizy marketingowe"
button1.SetProperties prop
else
ActiveDocument.Variables("Marketing").SetContent "1",true
set button1 = ActiveDocument.getsheetobject("BU63")
set prop = button1.GetProperties
prop.Text.v = "Ukryj analizy marketingowe"
button1.SetProperties prop
end if
end sub
</code>

Firstly you need to define a variable (in my case variable is marketing) then put this variable to show condition in sheet

<code>

Marketing=1

</code>

Sorry for my English. I didn't use it from years and now i have to to start again:)

Sheet Restrtiction(URGENT)

Thu, 22 Sep 2011 21:03:58 GMT

Hi there!!!

Excellent answers in the blog. you guys are lifesavers.

I have a question: Can you use a varible value as a parameter for a function in a macro? I have set ch=ActiveDocument.GetSheetObject("CH29"), and I want to replace the "CH29" portion with the content of the variable vREP_ID. I tried ch=ActiveDocument.GetSheetObject(vREP_ID), but it didn't work.

muchas gracias!!!!

Mauricio Cervantes

Sheet Restrtiction(URGENT)

rwunderlich — Thu, 22 Sep 2011 21:21:29 GMT

You have to make an API call to get the variable value first.

str = ActiveDocument.GetVariable(varname).GetContent.String

SET ch=ActiveDocument.GetSheetObject(str )

Sheet Restrtiction(URGENT)

Thu, 22 Sep 2011 21:30:41 GMT

ROB!!!!!!!!

You don't know it, but your comments have help me a lot!!!!

Thanks so much for your advice. It's just what I needed.

Hope to be able to pay back to the community one day!!!

saludos

Mauricio Cervantes