topic Re: Section Access * Issues in QlikView

Section Access * Issues

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

Hello All,

For the Section access I use excel and then load it in to INLINE table.

Now my problem is regarding * .

When I use * for all values it doesn't work.

Please provide me alternate solution.

Regards,

Sundar

Re: Section Access * Issues

Peter_Cammaert — Mon, 02 Nov 2015 10:01:18 GMT

Loading an Excel into an INLINE table is pretty much impossible. I guess you mean something else.

Did you use the STAR IS *; statement?

What do you mean with '...I use * for all values...'? The *-mechanism in a Section Access table is limited to 'all values in the same column in that same table. Not all values you encounter in your data model.

Peter

Re: Section Access * Issues

Anonymous — Mon, 02 Nov 2015 10:08:13 GMT

Try Peter's suggestion with Star statment.

Else you need to define all the fields one by one if not Star statement

Re: Section Access * Issues

rubenmarin — Mon, 02 Nov 2015 10:26:31 GMT

As said above '*' in section access means something like "all the values previously loaded in section access for this field". To use * like it was "all values" I first load the admin security with all values, after this all the fields has all values and '*' works as expected, in example:

Section application;

Data:

LOAD COUNTRY, Sales From...

Section access:

Access:

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, ADMINISTRATOR

];

Join LOAD Distinct COUNTRY Resident Data;

Concatenate (Access) // From here you can add usual security and '*' in COUNTRY will load all loaded values.

...