topic Re: Show blank QlikView dashboard in access point for users not in section access in App Development

Show blank QlikView dashboard in access point for users not in section access

bhargavikn — Mon, 20 Feb 2023 06:45:09 GMT

Hello Experts,

Need to implement section access for QlikView dashboard.

Normally if users are not added in section access, they will get 'access denied' while trying to open dashboard from QlikView access point.

but in my case 'it should allow to open the dashboard but with blank sheets(hiding all data),If users are not added in security'.

Could you please help me to achieve this requirement.

your help is highly appreciated.

Thank you.

Re: Show blank QlikView dashboard in access point for users not in section access

marcus_sommer — Mon, 20 Feb 2023 13:30:27 GMT

In some way you are describing already a possibility - simply adding those users within the section access. This doesn't mandatory mean to give them also access to confidential data - helpful may some dummy-data ...

Another and probably more expedient approach could be to hide these applications within the access point which is a document option in tab server (bottom right) which hides the application for all not listed users.

Re: Show blank QlikView dashboard in access point for users not in section access

bhargavikn — Wed, 01 Mar 2023 12:41:37 GMT

Hi Marcus,

Thanks for your Input.

Could you please explain, how we can add dummy data and it will reflect for all the columns in data model.

Re: Show blank QlikView dashboard in access point for users not in section access

marcus_sommer — Wed, 01 Mar 2023 13:48:24 GMT

Probably there is a field like country or region used for the section access. To this you may add the dummy-data, for example with:

concatenate(RegionDimTable) load 'DUMMY' as REGION autogenerate 1;

to the data-model within the section application area and within the section access area something like:

concatenate(SectionAccess)
load * inline [
ACCESS, NTNAME, REGION
USER, USER1, DUMMY
USER, USER2, DUMMY
...
];

The normal users haven't listed the DUMMY region and shouldn't see this value and the excluded users have only this DUMMY value without any other related values from the data-model. In this way they are listed and have at least a single available value within the data-set and shouldn't be excluded anymore. The value itself is completely useless.