Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Section access - problem with reduce data when field includes more one word

Hi all!

I have some problem with section access.

I must reduce data by filter "KLASTER"

i use this script:

Section Access;
star is *;

LOAD ACCESS,
USERID,
PASSWORD,
[KLASTER] as 'KLASTER'

FROM
F:\ACCESS_klaster.xlsx
(
ooxml, embedded labels, table is Access);


The field  KLASTER includes more one word, ie: [Кластер ВВД 02 Владимир] or [Кластер ВВД 03 Нижний Новгород]:

access.png



So, my Section Access doesn'r work. But if i generate ID (autonumber(KLASTER)) and than use ID in my SA, it wiil work fine.

But my customer wants to use field value (not id), becouse it is easy to support.

Could you help me and tell me how i should to write my script?

1 Solution

Accepted Solutions

Re: Section access - problem with reduce data when field includes more one word

There should be no difference between using a text with several words or an ID. But there are a couple of other things that can cause problems:

  1. You need to use UPPER case, i.e. Upper(Klaster) as KLASTER
  2. If the user has ADMIN rights, the reduction sometimes will not take place.

HIC

View solution in original post

3 Replies

Re: Section access - problem with reduce data when field includes more one word

There should be no difference between using a text with several words or an ID. But there are a couple of other things that can cause problems:

  1. You need to use UPPER case, i.e. Upper(Klaster) as KLASTER
  2. If the user has ADMIN rights, the reduction sometimes will not take place.

HIC

View solution in original post

Not applicable

Re: Section access - problem with reduce data when field includes more one word

Thanks! I have tried 1st  part - UPPER(KLASTER)  and it works fine! Thanks, thanks,  thanks,  thanks,  thanks,  thanks,  thanks!!!!!

Re: Section access - problem with reduce data when field includes more one word

Не за что


HIC