topic Re: Numbers in locations not getting mapped in section access in QlikView

Numbers in locations not getting mapped in section access

hbandari3636 — Tue, 09 Aug 2016 19:28:38 GMT

Hi All,

I have a location column defined in section access where based on the users location entered in the details it gets mapped to column Location in Location table. Its getting correctly mapped if I use combination of words and letters like example 'B44' or 'A23' etc but if there are locations are in full number format '092' or '084' the result is showing all the locations in default.

Thanks in Advance.

Regards

Hemantha

Re: Numbers in locations not getting mapped in section access

adamdavi3s — Wed, 10 Aug 2016 07:08:09 GMT

Sounds like it could be an issue with preceeding 0's being dropped?

Without some data or a sample dashboard I am afraid we can only speculate

Re: Numbers in locations not getting mapped in section access

marcus_sommer — Wed, 10 Aug 2016 09:13:13 GMT

It sounds that you didn't enable strict exclusion: Section Access: Strict Exclusion but before going on make sure that you have some BACKUP's of your application.

- Marcus