topic Re: KPI LEVEL SECTION ACCESS in QlikView

KPI LEVEL SECTION ACCESS

abhaysingh — Sun, 13 Sep 2015 06:34:56 GMT

Hi Guys,

i have one KPI Level Section Access Requirement in which suppose i have zone and region wise Sales Available IN ONE REPORT AND zone and Region wise Budget in another report.

so i have two reports, which shows

1- Zone & Region wise Sales

2- Zone & Region wise Budget

so, when i login through user1 so he can able to see in his-

1st report, Zone wise Sales

2nd Report, Region wise Budget

but in the same dashboard when user2 login than than he is able to see

1st report,Region wise Sales

2nd report, Zone wise Sales

do any one has idea how i can achieve it?? is it possible ??

regards

Abahy

Re: KPI LEVEL SECTION ACCESS

abhaysingh — Sun, 13 Sep 2015 14:01:06 GMT

hey guys any suggestions??

Re: KPI LEVEL SECTION ACCESS

fkeuroglian — Sun, 13 Sep 2015 15:08:30 GMT

Hi abhay

You can not use section acces using the OMIT field becuase you have to show in one report or another the fields.

but you can try using the CONDITION in each object for the expression you dont have to show

for example, put a conditional dimension to show "region" and "zone"

Add Calculated dimension

if(Osuser()="User1",Zone) and do the same with region

try this, hope help

Fernando K.

Re: KPI LEVEL SECTION ACCESS

Anonymous — Sun, 13 Sep 2015 15:08:40 GMT

Hi Abhay,

Please try as below:

“Settings” -> “Document Properties” -> “Opening” --

Tick the checkbox “Initial Data Reduction Based on Section Access”

to enable section access in the document.

And also Tick the checkbox “Strict Exclusion” - Access to the document will be denied whenever the field values in the section access reduction fields lack matches in their corresponding section application field. Having this option unselected will mean that if QlikView can’t find a match to reduce data, all data in the document will be visible on USER level. However, ADMIN will always be able to see all data, regardless of the reduction. Best practice is to use strict exclusion to avoid unwanted access to the QlikView document.

Write below code in hidden script:

Section access for Zone & Region wise Sales for report1

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION,ZONE

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, ,*

USER, USER2, U2, *, ];

Section Application;

SALES: LOAD * INLINE [

REGION,ZONE,SALES

AFRICA,ZONE1,1000

AMERICA,ZONE2, 2000

ASIA,ZONE3, 3000

EUROPE,ZONE4, 4000

OCEANIA,ZONE5, 5000 ];

Section access for Zone & Region wise Budget for report2

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION,ZONE

ADMIN, ADMIN, ADMIN,

USER, USER1, U1,* ,

USER, USER2, U2,,* ];

Section Application;

SALES: LOAD * INLINE [

REGION,ZONE,BUDGET

AFRICA,ZONE1,1000

AMERICA,ZONE2, 2000

ASIA,ZONE3, 3000

EUROPE,ZONE4, 4000

OCEANIA,ZONE5, 5000 ];

Regards

Neetha

Re: KPI LEVEL SECTION ACCESS

abhaysingh — Sun, 13 Sep 2015 15:53:39 GMT

HI NEETHA,

THANKS FOR REVERT, COULD YOU PLS TELLME WHY TWO SECTION ACCESS CODES??? I WANT THESE TWO REPORT IN ONE DASHBOARD ONLY...

COULD U PROVIDE ME SAMPLE APP PLEASE??

THANKS

ABHAY

Re: KPI LEVEL SECTION ACCESS

Anonymous — Mon, 14 Sep 2015 07:07:07 GMT

please provide data,will modify according to your requirement

Re: KPI LEVEL SECTION ACCESS

qlikviewwizard — Mon, 14 Sep 2015 08:33:50 GMT

Hi Check this threads:

Section Access

Level Wise Security Access

Column level access using Section Access

Sheet level access

Type of Security