Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zhadrakas
Specialist II
Specialist II

OMIT Problem

Hello,

i have encountered a weird behavior in Section Access with OMIT field.

Im using QlikView 11.

Document Settings:

Szenario 1) Script)

OMITgroup in Inline Table: This works fine

Section Access;

OMITGROUP:
Load * inline [
OMITGROUP, OMIT
Group1, Field1
Group1, Field2
Group1, Field3
Group1, Field4
]
;

OMIT:
load * inline [
ACCESS, NTNAME, OMITGROUP
ADMIN, DOMAIN\USER, 
USER, DOMAIN\USER1, Group1
]
;

Section Application;
Star is *;

Szenario 1) Ouput)

works as expected. Fields are not available

Szenario 2)

Add Users with Omitgroup via concatenate Load. This doesn't work

Section Access;

OMITGROUP:
Load * inline [
OMITGROUP, OMIT
Group1, Field1
Group1, Field2
Group1, Field3
Group1, Field4
]
;

OMIT:
load * inline [
ACCESS, NTNAME, OMITGROUP
ADMIN, DOMAIN\USER, 
]
;

Concatenate (OMIT)
LOAD 'USER' as ACCESS,
'DOMAIN\USER1' as NTNAME,
'Group1' as OMITGROUP
  
AutoGenerate (1);

Section Application;
Star is *;

Szenario 2) Output)

Omit doesnt work

Can anyone explain me why this happens?

Regards

tim

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

In my experience qv doesn't seem to like the SA table to be created in more than one part (the concatenation). If you need to because you have e.g. different sources then create that table outside of the SA part first and store it in e.g. a qvd. Then in SA load that qvd in one go.

View solution in original post

3 Replies
michael123
Partner - Creator
Partner - Creator

I get exactly the same result as you in scenario 1 when copying your scenario 2 into a load script.

QV 11.2 SR9.

/Michael

stigchel
Partner - Master
Partner - Master

In my experience qv doesn't seem to like the SA table to be created in more than one part (the concatenation). If you need to because you have e.g. different sources then create that table outside of the SA part first and store it in e.g. a qvd. Then in SA load that qvd in one go.

zhadrakas
Specialist II
Specialist II
Author

Thank you for your answers.

I have tested a lot:.

Both Szenarios are working fine if all instances of omitgroup are in uppercase.

But i think its Still better to source that part out and load it resident in section Access.