topic Re: Section Access issue if reduction field value is not in datamodel in QlikView

Section Access issue if reduction field value is not in datamodel

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi all

how to handle if customer is not available in data model which is added in section access

requirement : My requirement is don't show any data if customer is not available in data model

ex:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, ORDERCUSTOMERNAME, STOCKCUSTOMER

ADMIN, Mydomain\satish,

USER, Mydomain\KSTL, "MICHEL", "MICHEL"

];

Section Application;

StockData:

Load Upper([StockCustomer Name]) as STOCKCUSTOMER, * Inline [

StockCustomer Name ,Value

Rocky, 434

Mark, 43434

Mark, 232

Mark, 5454

Ruceety,43

baker, 965

baker, 445

];

here MICHEL is not available in data here i don't want to show all customers data

but now it displaying all data in sheet

please check sample application

swuehl‌adamdavi3s‌stevedark‌

Re: Section Access issue if reduction field value is not in datamodel

rahulpawarb — Wed, 01 Mar 2017 11:20:58 GMT

Hello Sreeranga,

Have you selected Strict Exclusion check box present under Opening tab of Document Properties? If no then tick this check box and click OK. Close the application and try to open it with specific user to see the desired results.

Hope this will be helpful.

Regards!

Rahul

Re: Section Access issue if reduction field value is not in datamodel

Anonymous — Wed, 01 Mar 2017 13:14:45 GMT

i did same i tried with by enable strict exclusion in document props

but iam unable to open qvw file its saying that Access denied to qlikview document

Re: Section Access issue if reduction field value is not in datamodel

muthukumar77 — Thu, 02 Mar 2017 10:03:41 GMT

Hi,

Try like this,

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, CODE

ADMIN, ADMIN, 1

USER, Mydomain\KSTL, 2

];

Section Application;

STAR is *;

Group:

LOAD * INLINE [

CODE, ORDERCUSTOMER, STOCKCUSTOMER

1, *, *

2, Michel, Michel

];

OrdersData:

LOAD *, [OrderCustomer Name] as ORDERCUSTOMER;

Load * Inline [

OrderCustomer Name , Order Id, Scheduled Date, Actual Date, Actual Time,Scheduled Time

steve, ORD1, 2016-01-06 00:00:00.000, 2016-01-06 00:00:00.000, 16:05:00, 16:05:00

Mark, ORD77,2016-01-18 00:00:00.000 ,2016-07-18 00:00:00.000, 14:00:00, 14:00:00

Mark, ORD2,2016-01-18 00:00:00.000 ,2016-01-18 00:00:00.000, 14:00:00, 14:00:00

Michel, ORD3, 2016-01-07 00:00:00.000 ,2016-01-07 00:00:00.000, 14:05:00, 14:05:00

Michel, ORD55, 2016-01-05 00:00:00.000 ,2016-01-07 00:00:00.000, 14:05:00, 14:05:00

Michel, ORD25, 2016-01-05 00:00:00.000 ,2016-01-07 00:00:00.000, 14:07:00, 14:05:00

Michel, ORD75, 2016-01-05 00:00:00.000 ,2016-01-07 00:00:00.000, 14:02:00, 14:05:00

Mark, ORD66,2016-01-18 00:00:00.000 ,2016-01-18 00:00:00.000, 14:15:00, 14:00:00

Ruceety,ORD4, 2016-01-06 00:00:00.000, 2016-01-06 00:00:00.000, 13:00:00, 13:00:00

baker, ORD5,2016-01-07 00:00:00.000, 2016-01-07 00:00:00.000, 14:30:00, 14:30:00

baker, ORD7,2016-01-07 00:00:00.000, 2016-01-07 00:00:00.000, 14:31:00, 14:30:00

];

StockData:

LOAD *, [StockCustomer Name] as STOCKCUSTOMER;

Load * Inline [

StockCustomer Name ,Value

Rocky, 434

Mark, 43434

Mark, 232

Mark, 5454

Ruceety,43

baker, 965

baker, 445

];

Re: Section Access issue if reduction field value is not in datamodel

muthukumar77 — Thu, 02 Mar 2017 10:09:00 GMT

Before reload do,

Qlikview Setting -> Document properties -> Opening -> Check ,

Initial Data reduction based on section access and Apply.

Then Close and Open the Qlikview app.

Re: Section Access issue if reduction field value is not in datamodel

Anonymous — Thu, 02 Mar 2017 14:46:30 GMT

I tried it its working fine but issue with

OrdersData : it has Michel customer but it is not filtering by Michel though i assigned 2 for Michel

StockData: its working as expected

Like below

Order:

here i should able to see only Michel data in first sheet

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, CODE

ADMIN, PRASAD\satish,1

USER, PRASAD\KSTL,2

];

Section Application;

STAR is *;

Group:

LOAD * INLINE [

CODE, ORDERCUSTOMER, STOCKCUSTOMER

1, *, *

2, "MICHEL","MICHEL"

];

OrdersData:

Load Upper([OrderCustomer Name]) as ORDERCUSTOMERNAME, * Inline [