topic Is there a possibility to drop sheets dynamically based on user? in QlikView

Is there a possibility to drop sheets dynamically based on user?

Anonymous — Wed, 15 Feb 2017 10:35:10 GMT

Hi Team,

As our application has several sheets and plenty of objects in them, it has become very heavy. Not all sheets are required for all users. Therefore is there a possibility to drop sheets based on user LogIn? I am not talking about hiding sheets here.

Can we only have the sheets required by the user when he logs in? Please let me know.. This is urgent..

Re: Is there a possibility to drop sheets dynamically based on user?

sarvesh — Wed, 15 Feb 2017 10:47:59 GMT

Hi..

You can delete this sheet from App.

Regard's

Sarvesh Srivastava

Re: Is there a possibility to drop sheets dynamically based on user?

vardhancse — Wed, 15 Feb 2017 11:25:13 GMT

Section access for sheet level can be done.

If hiding was not the requirement, then you can create separate dashboards for the user types.

In general will follow section access to hide and show the sheet.

If you are more concerned about space try to split the dashboards based on some field using document chaining.

Re: Is there a possibility to drop sheets dynamically based on user?

sasikanth — Wed, 15 Feb 2017 11:38:14 GMT

Hi,

If you have Publisher in setup then go for " Loop and Reduce" option.

it will divide the Large application into several small apps based on the given FIELD.

Re: Is there a possibility to drop sheets dynamically based on user?

Anonymous — Wed, 15 Feb 2017 15:31:57 GMT

Apply section access on sheet level like below

=if(Match(OSUser,'dev','lakky'),1,0)

Regards,

Devendar