topic Re: Section access space issue in QlikView

Section access space issue

Fri, 14 Aug 2015 14:27:03 GMT

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.

Re: Section access space issue

Gabriel — Fri, 14 Aug 2015 14:56:59 GMT

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

Re: Section access space issue

Fri, 14 Aug 2015 14:59:28 GMT

Spaces between data values

As you can see above AS BCD and AS CVD

Re: Section access space issue

Fri, 14 Aug 2015 15:02:49 GMT

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
]

Re: Section access space issue

Clever_Anjos — Fri, 14 Aug 2015 15:05:20 GMT

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

Re: Section access space issue

Peter_Cammaert — Fri, 14 Aug 2015 15:07:27 GMT

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

Re: Section access space issue

Gabriel — Fri, 14 Aug 2015 15:35:09 GMT

Hi,

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

Re: Section access space issue

Fri, 14 Aug 2015 15:45:07 GMT

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