topic Challenge for Qlik gurus/experts [QVW attached]: How to show all the values from a table where Section Access Field reduction is happening? I want to show all the buyers, not just the ones who purchased in QlikView

Challenge for Qlik gurus/experts [QVW attached]: How to show all the values from a table where Section Access Field reduction is happening? I want to show all the buyers, not just the ones who purchased

jblomqvist — Mon, 26 Jan 2026 18:19:17 GMT

Hello Qlik experts,

I have the following request from users.

In our application we have section access where field reduction is happening.

This means users can only see Buyers where they have purchased something.

What the users also want is the list of ALL the buyers, the ones who have purchased but also not. If they select a Buyer it should filter and measures update, if nothing is selected then show all the buyers.

How is this possible in a data model where field reduction is happening with section access?

The QVW is attached with sample data. Use JOESMITH as UserID to log in, no password required.

This is what the Buyers table looks like with all the values, this is the desired outcome when nothing is selected.

However when Joe Smith logs in, he is only able to see because of field reduction based on his data:

What he should see by default is what is available in the first screenshot above.

How is this possible?

Re: Challenge for Qlik gurus/experts [QVW attached]: How to show all the values from a table where Section Access Field reduction is happening? I want to show all the buyers, not just the ones who purchased

petter — Sat, 23 Jun 2018 12:43:12 GMT

What is the user id and password for an admin access to this QVW?

Re: Challenge for Qlik gurus/experts [QVW attached]: How to show all the values from a table where Section Access Field reduction is happening? I want to show all the buyers, not just the ones who purchased

jblomqvist — Sat, 23 Jun 2018 13:01:20 GMT

Hi Peter,

Thank you for trying to help. There isn't an admin access.

I have attached the script if it helps.

Re: Challenge for Qlik gurus/experts [QVW attached]: How to show all the values from a table where Section Access Field reduction is happening? I want to show all the buyers, not just the ones who purchased

Miguel_Angel_Baeyens — Mon, 25 Jun 2018 09:14:04 GMT

You can create a separate table with the buyers not associated with the rest of the model. Then, to select values from that table, use function P() in the set analysis of the expressions.

As long as the table of Buyers is associated, it will be reduced.

You can also replicate the data for buyers with some fake ids and allow all users access to this fake id. Something similar to this: Mask or de-identify data for certain users using Section Access.