topic Re: OMIT Problem in QlikView

OMIT Problem

zhadrakas — Tue, 27 Feb 2018 10:54:32 GMT

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

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

Re: OMIT Problem

michael123 — Tue, 27 Feb 2018 12:21:27 GMT

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

Re: OMIT Problem

stigchel — Tue, 27 Feb 2018 12:32:53 GMT

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.

Re: OMIT Problem

zhadrakas — Wed, 28 Feb 2018 08:33:50 GMT

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.