This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Apologies but having read several threads, I'm no nearer to getting this to work.
Here are my scripts
load * inline [
ACCESS, USERID, BUSINESSUNIT, OMIT
USER, AGGUK\tim saddler,4501399,
USER, AGGUK\helen chapman, 4224399,
screenshot of QMC user ids
Any pointers would be most appreciated
Thanks in advance
You don't have NTNAME in Qlik Sense, only UserId & Groups, identical to the QMC.
Sections in the script ‒ Qlik Sense
Not field names or field values!
I think our issues revolve around interpretation of this phrase in the manual
Basically am I
QMC screenshot below
Try writing your userid value in upper case, e.g. [AGGUK\TIM SADDLER]
Even preferably, when loading the data, use the Upper() function on UserID.
Hi Martin, I think you misinterpreted my statement, I meant all field names and field values in the Section access table needs to be in uppercase.
This is indeed what the Qlik Sense manual is stating so you definitely got a valid point. However,for dynamic data reduction party, the fieldnames & field values have to be identical to the one in the data model as they are case-sensitive.
A couple things to try:
Here is a screenshot of what mine looks like (which works) for comparison.
If I can add to @Tim Kendrick avoid spaces in userids if you can help it.
Prior to Qlik Sense 2.2, there was an issue with Section access and non-url encoded values. So you may have to enter an urlencode character for the space %20.
In addition, no need for the omit column if you aren't using it. you do need to mark section application, whether your load comes before or after section access statement.
The question I have is what does your data look like after you load this script?
That are absolutely correct Martin. Hence you need to duplicate all the fields in the data model in uppercase which involved in the section access .
I have tested this and it works even if the values are lower case in the section access table.