topic Re: Displaying objects as per user rights in QlikView

Displaying objects as per user rights

Tue, 19 Aug 2014 07:08:22 GMT

So when user1 logs in, it should display

Pivot table 1

Hello,

I have 2 pivot tables and depending on user rights it should display the object.

Layout is as below.

Pivot table 1

Pivot table 2

I have 3 users: user1, user2 and user3

user1 is having access to Pivot table 1

user2 is having access to Pivot table 2

user3is having access to both Pivot table 1 and Pivot table 2.

So when user1 logs in, it should display

Pivot table 1

So when user2 logs in, it should display

Pivot table 2

So when user3 logs in, it should display

Pivot table 1

Pivot table 2

So how to make it working.

Re: Displaying objects as per user rights

tresB — Tue, 19 Aug 2014 07:47:46 GMT

See: Object level security

Re: Displaying objects as per user rights

ashfaq_haseeb — Tue, 19 Aug 2014 07:50:23 GMT

Hi Rupali,

You can do the same with osuser() function.

Right click on your chart1 --> Properties --> Layout --> Select Conditional

and write below code.

If(osuser()='Domain\user1',1,0)

Simultaneously do the same for the other users and charts.

Regards

ASHFAQ

Re: Displaying objects as per user rights

jagan — Tue, 19 Aug 2014 07:55:53 GMT

Hi,

Check this thread, hope it helps you.

Chart Level Access by user

Regards,

Jagan.

Re: Displaying objects as per user rights

Tue, 19 Aug 2014 08:35:46 GMT

Hello Jagan,

Ya using this option we can hide or show the pivot tables.

But then in my case, Pivot table 1 and Pivot table 2 are placed 1 below the other.

so when Pivot table 2 should be displayed, space required for pivot table 1 is blank and then below it Pivot table 2 is displayed.

and when user with both access, should be able to see Pivot table 1 and below it Pivot table 2.

Re: Displaying objects as per user rights

jagan — Tue, 19 Aug 2014 09:02:13 GMT

Hi,

It is not possible to change the coordinates of the charts based on the user, instead you can put the charts in container object, based on the user access the charts are displayed.

Hope this helps you.

Regards,

Jagan.

Re: Displaying objects as per user rights

Tue, 19 Aug 2014 09:28:43 GMT

Hello Jagan,

Yes tried with the container object with the grid style.

If we use single object type, then it displays object as per user access.

But if we use grid style, still it shows blank space when a object is not displayed.

so we cant change the coordinates in container also?

Re: Displaying objects as per user rights

jagan — Tue, 19 Aug 2014 09:30:44 GMT

Yes we cannot change the coordinates in container.

Re: Displaying objects as per user rights

Wed, 10 Sep 2014 05:35:50 GMT

Hello Jagan,

I am now using container object and it have solved my problem...

But then when I create report using Reports -> Edit Report section,

I am facing problem that is shows only 1 object at a time based on the selected tab.

e.g: if 1st tab of the container is selected, report will will show object of 1st tab, and when 2nd tab is selcted, it will show that object..

how can I resolve this issue?

Re: Displaying objects as per user rights

jagan — Wed, 10 Sep 2014 05:50:33 GMT

Hi,

It is not possible to handle the container objects in report, instead you can create the same set of objects and hide it behind the container and drag this objects into the report.

Hope this helps you.

Regards,

Jagan.

Re: Displaying objects as per user rights

Wed, 10 Sep 2014 05:55:01 GMT

ya, thought of this option,

but then it would increase the file size.

Re: Displaying objects as per user rights

jagan — Wed, 10 Sep 2014 06:07:21 GMT

Hi,

I wont increase the file size hugely, may be some 1 or 2 kb, I think this is not a problem.

Regards,

Jagan.

Re: Displaying objects as per user rights

Wed, 10 Sep 2014 06:58:02 GMT

okay.. will try and let you know.