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

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

Thu, 30 Jan 2014 17:49:26 GMT

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 Нижний Новгород]:

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?

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

hic — Thu, 30 Jan 2014 17:57:37 GMT

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:

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

HIC

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

Thu, 30 Jan 2014 18:05:24 GMT

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 — Thu, 30 Jan 2014 18:11:46 GMT

Не за что

HIC