topic Re: How to initialize variable with field value ? in QlikView

How to initialize variable with field value ?

Tue, 22 Dec 2015 07:14:35 GMT

Hi everybody ,

I have an section access in my application like this :

Load

ACCESS ,NAME , OMITGROUP

FROM myqvd.qvd ;

for any user , the field omitgroup have a diffrent value.

I'll like to initialize a variable with the value of this field when a user log in my application.
Is it possible ?

oknotsen — Tue, 22 Dec 2015 07:35:04 GMT

What do you actually want to achieve?

marcus_sommer — Tue, 22 Dec 2015 07:54:18 GMT

By section access be cautious and read the links here Section Access especially the Introductio very carefully.

Your example won't work because you could only use those fields which are specified for section access like:

Load

ACCESS, NTNAME , OMITGROUP

FROM myqvd.qvd where 1 = 1;

and it couldn't be an optimized qvd-load.

Your variable-issue isn't quite clear, do you mean something like:

varUser:

= osuser()

- Marcus

jagan — Tue, 22 Dec 2015 07:57:26 GMT

HI,

Try like this

Section Access;

Load

ACCESS ,NAME , OMITGROUP

FROM myqvd.qvd ;

Section Application;

Test:

Load DISTINCT

OMITGROUP

FROM myqvd.qvd ;

Now in variable just use Only(OMITGROUP).

Regards,

Jagan.

Tue, 22 Dec 2015 08:00:14 GMT

thank yuo , it work now