Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Section access space issue

Hi All,

I need to use section access for hierarchy level that have spaces. Is this possible?

section access;

load * inline

[ACCESS,PWD,Level

ADMIN,ADMIN,AS BCD

USER,USER,AS CVD

section application ;

I tried single quotes and double quotes but it doesn't seem to work.

Thanks for your help.

Tags (1)
7 Replies
Gabriel
Valued Contributor II

Re: Section access space issue

Hi,

What do you mean space?

Is this space coming as a result of NULL (missing value from database) or NULL (result of joins in QlikView) or space as in -?

Please try and clarify this or mest bet post a sample file

Best Regards

Not applicable

Re: Section access space issue

Spaces between data values

As you can see above AS BCD and AS CVD

Not applicable

Re: Section access space issue

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER1, USER1
USER, USER2, USER2
USER, USER3, USER3
];
Section Application;

LOAD * INLINE
[

USERID, Level
USER1,AS BCD
USER2,AS CVD
USER3,AS VDB
]

Employee
Employee

Re: Section access space issue

Level should be LEVEL (Fields into Section Access must be UPPERCASE)

Re: Section access space issue

INLINE tables don't threat quotes or double quotes any differently from other characters. There are only few special characters: comma, square brackets and CR/LF. All the others are taken as-is and included in the stored values. So if your values contain spaces (not leading or trailing, they will be omitted), include them in the INLINE specification exactly as they occur in your other fields. Specify AS BCD and AS CVD and they will be stored as strings 'AS BCD' and 'AS CVD'.

Remember that both field names and field values in an SA table are implicitly converted to UPPER CASE. For linking to work as expected, make sure that the corresponding fields in Section Application also have upper case names and contain upper case values.

Peter

Gabriel
Valued Contributor II

Re: Section access space issue

Hi,

Since this is INLINE table just add single quote ' to the value in the table

Not applicable

Re: Section access space issue

Space didn't bother  you in Inline table or section table  Are you facing any issue ?

Community Browser