Section access in Qlik Cloud is not working

[kjun0306]

Hi,

I have this in my Qlik Sense Data load script, but both users always see all names in Samples.

What did I miss?

[PrashantSangle · Accepted solution]

Only on correction, you have to do in while loading data

You must need to add reduction field in Load script too. it can ok if you avoid in select statement.

Load Name, ID, ID as REDUCTION;

Select Name, ID From Samples;

Regards,

Prashant Sangle

[Vegar · Accepted solution]

You need to have the REDUCTION field in that data model when script is finished. Try to include the REDUCTION field, or do the section access on the ID field instead  .

The data reduction is not done during script execution,  but when the app is opened by the user.

[kjun0306]

Thank you! That was it! I had REDUCTION in the select statement instead of LOAD section. It is working as expected now.