Discussion board where members can get started with QlikView.
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?
Go to Solution.
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:
View solution in original post
Thanks! I have tried 1st part - UPPER(KLASTER) and it works fine! Thanks, thanks, thanks, thanks, thanks, thanks, thanks!!!!!
Не за что