Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
hic
Former Employee
Former Employee

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
hic
Former Employee
Former Employee

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

Not applicable
Author

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

hic
Former Employee
Former Employee

Не за что


HIC