topic Re: Section Access in QlikView

Section Access

carolin01 — Mon, 24 Feb 2014 13:59:41 GMT

Hello together,

I need a little bit of help with my section Access. I don´t have yet the publisher therefore I´m working with an excel table where I manage the section access. This works actually fine for all fields but not for my field called "Company". If I reduce the data to company `100` then this is working. If I type `100, 200` this is not working:

It´s the only numeric field that I use for section access and it seems that it does not work if I enter more than one value. Any ideas?

Best regards

Carolin

Re: Section Access

nilesh_gangurde — Mon, 24 Feb 2014 14:09:20 GMT

Hi,

it should ideally work fine.

but please check that how you are giving the Comapny codes (i.e. 100,200) in the excel.

there should be the multiple entries for the same username to access the multiple companies.

hope this will help. or you can share the sample files.

-Nilesh

Re: Section Access

Mon, 24 Feb 2014 14:09:49 GMT

Carolin,

The different values must be entered in several lines (1 value per field per line)

Use subfield() function to split your field into several lines.

Fabrice

Re: Section Access

christophebrault — Mon, 24 Feb 2014 14:13:28 GMT

Hi,

You can read this great Post from hic .

Use the pdf attached, it shows how to you generic keys for complex authorization. I use this method in my section access and its very flexible.

Re: Section Access

salto — Mon, 24 Feb 2014 14:31:03 GMT

Hi Carolin,

try adding one line with '100' and other line with '200'

Regards.