topic Remove Sheets via Section Access Group in QlikView

Remove Sheets via Section Access Group

volcore79 — Wed, 15 Dec 2010 09:31:36 GMT

Hi,

see my attached file.

user.xlsx contains users and groups

rechte.xlsx contains groups and sheets

The QV File should read the excel files and remove the sheets 1 and 3 if the username is user1. Why doesn't this work ? could you please correct my example ?

Regards

Volker

Remove Sheets via Section Access Group

Wed, 15 Dec 2010 09:37:05 GMT

Hi Volker,

Please send your user name and password for qlikview application.

Regards,

Sri

AW:Re: Remove Sheets via Section Access Group

volcore79 — Wed, 15 Dec 2010 09:46:46 GMT

LOL Sorry !!

User is "user1"

Admin is "admin1"

There's no password..

Remove Sheets via Section Access Group

Wed, 15 Dec 2010 10:03:09 GMT

"The QV File should read the excel files and remove the sheets 1 and 3 if the username is user1. Why doesn't this work ? could you please correct my example ?" wats dis i cant understand wat u want excatly

AW:Re: Remove Sheets via Section Access Group

volcore79 — Wed, 15 Dec 2010 10:15:28 GMT

View the excel files rechte.xlsx and user.xlsx (connected via "GROUP"):

"user1" should see the Worksheet "Sheet2" in die QV Application. "Sheet1" and "Sheet3" have to be removed/invisible.

"admin1" should see all the Sheets.

In rechte.xlsx you'll find the GROUP and the Sheets (Headline) of my Application. If a GROUP should be able to "see" the Worksheet, there's a "1". If not, there's a "0".

AW:Re: Remove Sheets via Section Access Group

volcore79 — Wed, 15 Dec 2010 11:40:43 GMT

It should not be so hard. My Problem is the Connection between User and Group. This doesn't seem to work. Does anyone have an idea ? i really need this...

Remove Sheets via Section Access Group

Wed, 15 Dec 2010 13:17:31 GMT

Hi Volker,

please see the attached modified application.

Hope it helps.

Good luck!

Rainer