topic section access in QlikView

section access

vijetas42 — Thu, 22 Jun 2017 13:49:55 GMT

Hi all,

I am facing one issue with the section access is, I am having one qvw file where section access works on the particular field and now I have added one new table which which don't have that field and that new table is linked to existing data model and now when i open the dashboard it wont show me any data for the report which I have developed on newly added table.

So, now I want to bypass section access on the newly created table how to handle please suggest!

Re: section access

Peter_Cammaert — Thu, 22 Jun 2017 13:55:03 GMT

Section Access is an all-or-nothing affair. If you want to bring new data into a data model that is being reduced based on some linked section access value, and you want to include all of this table, you have to add a dummy connection that links to all of the rows in this new table at all times.

For example, add a field to your new table called DUMMYLINKFIELD and put a value of 'ALL' in every single cell of this field.

Then in all your Section Access rows, add a DUMMYLINKFIELD column with value 'ALL'. Reload.

Re: section access

vijetas42 — Fri, 23 Jun 2017 06:10:29 GMT

Hi Peter,

Thanks for your reply.I have tried ALL with dummy field but seems not working.Any other solution?

Re: section access

JM — Fri, 23 Jun 2017 06:42:38 GMT

Would you mind sharing your code.

Re: section access

kamal_sanguri — Fri, 23 Jun 2017 06:45:04 GMT

What level of section access you have and is the new table linked with old table with any field? Try making it island if that is the case. You can rename column or simply can use Qualify Statement.