Query with user id in section application

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

Hi,

I'm working on an application where I have to implement data reduction.

My section access is working like that:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, USERID, PASSWORD, IDGROUPE

ADMIN, ADMINQV, ADMINQV, ADMINQV, 1335692

];

Concatenate

LOAD

'USER' as ACCESS,

NTNAME,

IDGROUPE;

SQL select UPPER(s.SPSEUDOSALARIE) as NTNAME,

gs.IDGROUPE

from SALARIES s

inner join GROUPESSALARIES gs on gs.IDSALARIE = s.IDSALARIE

where s.IDCLIENT = '$(vIdClient)'

and s.BACTIVESALARIE = 1;

Section Application;

The authentification is working fine, now my problem is that the query for searching groups / entities is really huge (about 500 000 000 rows) so I would like to know if it was possible to do a query like that in section application:

LOAD *;

select IDGROUPE, IDENTITY

from TABLE

where iduser = xxx

where 'xxx' is the id of the user connected

Re: Query with user id in section application

Gysbert_Wassenaar — Mon, 04 Nov 2013 16:25:27 GMT

No, that's not possible. The user is not known when the document is reloaded.

Re: Query with user id in section application

Anonymous — Mon, 04 Nov 2013 16:43:12 GMT

Thanks! But that didn't solve my problem

I have to search

topic Re: Query with user id in section application in QlikView

Query with user id in section application

Re: Query with user id in section application

Re: Query with user id in section application