topic Section access and list box in QlikView

Section access and list box

Anonymous — Fri, 06 Nov 2015 10:05:43 GMT

Hi All,

I can find that there are some values are missing in the list box.

Especially null values (-------) while I was using the section access strict exclusion.

how can I aviod this it spoils the whole look and feel.

Regards,

Sundar

Re: Section access and list box

Mark_Little — Fri, 06 Nov 2015 12:53:26 GMT

Hi,

Can you post an example of what you mean, i.e. a before and after?

I think from the description people are only seeing what selectors they can access via the set up of the section access. As far as i am aware that is how section access works when reducing the data.

An option could be checking peoples access on individual charts and objects and not reducing the data, but it can be a lot of work.

Mark

Re: Section access and list box

marcus_sommer — Fri, 06 Nov 2015 13:41:19 GMT

By using section access with strict exclusion a user could only see/access data to which he/she is associated to and I think this isn't possible with NULL even if you used a star is *; wildmatch - it will be applied only to real values.

This meant you need to fill NULL with real values, maybe like:

if(len(trim(YourField))=0, 'NULL / Missing Values', YourField)

More to NULL could you find here: Finding NULL.

- Marcus

Re: Section access and list box

Anonymous — Fri, 06 Nov 2015 13:44:02 GMT

You can do at script level for that list box field like:

if(len(trim(FieldNAme))>0,'FieldNAme') as FieldNAme