topic Re: Section Access/Application using a * in QlikView

Section Access/Application using a *

renjithpl — Tue, 08 Sep 2015 02:01:19 GMT

Hi All,

Below is my section access/application script.

I want NTNAME B to see all the dashboard.

When I use this, i get no data in it.

Why * does not work in this case.

SECTION Access;
LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN, A
    USER, B
    USER, C
];

SECTION Application;
LOAD * INLINE [
    NTNAME, DASHBOARD
    A, sales.qvw
    A, finance.qvw
    B, *
    C, sales.qvw
];

Thanks

Ren

Re: Section Access/Application using a *

sinanozdemir — Tue, 08 Sep 2015 02:07:27 GMT

Hi Renjith,

Try blank instead of *:

LOAD * INLINE [

NTNAME, DASHBOARD

A, sales.qvw

A, finance.qvw

C, sales.qvw

];

Hope this helps.

Re: Section Access/Application using a *

renjithpl — Tue, 08 Sep 2015 02:17:13 GMT

I have tried using blank, dint work.

Re: Section Access/Application using a *

sinanozdemir — Tue, 08 Sep 2015 02:18:49 GMT

I edited it, don't use comma after B at all.

LOAD * INLINE [

NTNAME, DASHBOARD

A, sales.qvw

A, finance.qvw

C, sales.qvw

];

Re: Section Access/Application using a *

sinanozdemir — Tue, 08 Sep 2015 02:23:57 GMT

You may also need to use upper letters for the dashboard names as well.

Re: Section Access/Application using a *

renjithpl — Tue, 08 Sep 2015 03:40:55 GMT

tried all, nothing seems to be working

Re: Section Access/Application using a *

jonathandienst — Tue, 08 Sep 2015 06:04:49 GMT

There's no special meaning for * in the Section Application part of the script.

What are you trying to achieve?

Do you want to map B to all 3 file names?

What are you doing with these file names?

Perhaps this is what you need:

Section Application;

T_Dashboards:

LOAD * INLINE [

NTNAME, DASHBOARD

A, sales.qvw

A, finance.qvw

B, *

C, sales.qvw

];

Dashboards:

LOAD NTNAME

Resident T_Dashboards

Where DASHBOARD = '*';

Join (Dashboards)

LOAD Distinct DASHBOARD

Resident T_Dashboards

Where DASHBOARD <> '*';

Concatenate (Dashboards)

LOAD NTNAME, DASHBOARD

Resident T_Dashboards

Where DASHBOARD <> '*';

DROP Table T_Dashboards;

Re: Section Access/Application using a *

renjithpl — Tue, 08 Sep 2015 06:13:29 GMT

Hi Jonathan,

My dimension table has the filed "dashboard names" with values sales.qvw, finance.qvw.....

I want user B to view all the values, i thought using * will help. But when I am reducing the data and when USER B opens the document he can only nothing other than "*".

thanks

Re: Section Access/Application using a *

Anonymous — Tue, 08 Sep 2015 06:18:33 GMT

Try:

B, app1

B, app2

B, app3

like this. * does not work like you specified in section access. I had same experience on field level.

Re: Section Access/Application using a *

jagan — Tue, 08 Sep 2015 06:25:12 GMT

HI,

Try like this

SECTION Access;

Security:
LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN, A
    USER, B
    USER, C
];

LEFT JOIN (Security)

LOAD *

INLINE [

NTNAME, DASHBOARD

A, sales.qvw

A, finance.qvw

B, *

C, sales.qvw

];

SECTION Application;

App_Data:
LOAD

DISTINCT DASHBOARD

INLINE [
    DASHBOARD
   sales.qvw
    finance.qvw
   sales.qvw
];

Hope this helps you.

Regards,

Jagan.

Re: Section Access/Application using a *

jagan — Tue, 08 Sep 2015 06:34:29 GMT

Hi,

Check this link for sample code.

Authentication and Authorization in Qlikview

Regards,

Jagan.

Re: Section Access/Application using a *

sunilkumarqv — Tue, 08 Sep 2015 07:15:44 GMT

star *

SECTION Access;
LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN, A
    USER, B
    USER, C
];

SECTION Application;
LOAD * INLINE [
    NTNAME, DASHBOARD
    A, sales.qvw
    A, finance.qvw
    B, <ALL>
    C, sales.qvw
];

STAR is *;

SECTION Access;
LOAD * INLINE [
    ACCESS, NTNAME
    ADMIN, A
    USER, B
    USER, C
];

SECTION Application;
LOAD * INLINE [
    NTNAME, DASHBOARD
    A, sales.qvw
    A, finance.qvw
    B, *
    C, sales.qvw
];

Re: Section Access/Application using a *

renjithpl — Tue, 08 Sep 2015 10:01:52 GMT

Thanks everybody.

Using Star is *; before the section application line, worked how i wanted.

Re: Section Access/Application using a *

avinashelite — Tue, 08 Sep 2015 10:38:45 GMT

hey Renjith,

USING B userid where you able to get data for all?? if so can you share the sample file please .