topic Re: How to create section access in Qliksense? in QlikView

How to create section access in Qliksense?

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can I do section access or security purpose in Qliksense?If yes, please give me an instruction for that.

Thanks,

Sandip

lironbaram — Thu, 12 Jan 2017 06:37:54 GMT

you can create section access in Qlik sense

it's quite similar to Qlikview

have a look here

ananyaghosh — Wed, 18 Jan 2017 09:26:59 GMT

hi,

I have used below code for section access:

section access;

LOAD * inline [

ACCESS, USERID,PRD_ID,OMIT

USER, MFCGD\kharega,56775,

USER, MFCGD\ghsandi,54095,

USER, MFCGD\iniyaan,*,

];

section application;

T1:

Load UPPER(PRD_ID) as PRD_ID,

PRD_NAME AS PRODUCT_NAME resident [Product];

Now I want to use more than one data reduction field like PRD_ID, PRD_NAME, PRD_CODE etc. Is it possible to use them in 'section access' section?

lironbaram — Wed, 18 Jan 2017 09:53:10 GMT

you can use more than one reduction field

just create other tables with the fields you want to use

some good ideas can be find here