Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

section access

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!

4 Replies
Peter_Cammaert
Partner
Partner

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.

vijetas42
Specialist
Specialist
Author

Hi Peter,

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

JM
Contributor III
Contributor III

Would you mind sharing your code.

kamal_sanguri
Specialist
Specialist

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.