topic Re: Section Access issue with column names in QlikView

Section Access issue with column names

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

Hi every one my requirement is to implement section access in my dashboard

in my

dashboard there are 2 sheets 1.Orders 2. stock and

2 tables 1.OrdersData 2.StockData

i have same customer in both tables with different column names (ORDERCUSTOMERNAME,StockCustomer Name)

my issue is i unable to apply section access in both sheets

my requirement is when customer logged in it should apply in both sheets

ex: when MICHEL Logged in it show only michel data

like below

issue:

but how could i see same behavior in stocks sheet(with different column names i don't want to create synthetic key)

Attached Sample Application for reference

swuehl‌stevedark‌adamdavi3s‌

Re: Section Access issue with column names

adamdavi3s — Tue, 28 Feb 2017 12:21:57 GMT

We can't access your qvw as its got section access on it.

The simplest way is just to add a second column on your section access script for the stockcustomer and populate it with the same data

Re: Section Access issue with column names

Anonymous — Tue, 28 Feb 2017 12:29:33 GMT

i just updated my qvw file please check adamdavi3s‌

Re: Section Access issue with column names

Miguel_Angel_Baeyens — Tue, 28 Feb 2017 12:31:54 GMT

Indeed, you can use several columns to reduce data, and if your stock and orders and in a separate table, that is the only way of doing it.

You can also create a fact table where you differentiate stocks from orders and then the section access would likely be simpler.

Re: Section Access issue with column names

adamdavi3s — Tue, 28 Feb 2017 12:50:51 GMT

Just do this?

//Section Access;

//LOAD * INLINE [

// ACCESS, NTNAME, ORDERCUSTOMERNAME,StockCustomer

// ADMIN, MyDomain\satish,

// USER, MyDomain\KSTL, "MICHEL", "MICHEL"

//];

//Section Application;

Re: Section Access issue with column names

Peter_Cammaert — Tue, 28 Feb 2017 13:22:01 GMT

Maybe with SA column names in upper case (actually converted automatically in SA, but anyway) and their counterparts in Section Application too

Re: Section Access issue with column names

adamdavi3s — Tue, 28 Feb 2017 13:25:19 GMT

haha yes I am lazy and let SA do the work...

Re: Section Access issue with column names

Miguel_Angel_Baeyens — Tue, 28 Feb 2017 13:27:58 GMT

Couple of notes after opening your file:

There can be only one single section access table. If you need, you can use several columns to reduce by, in your case "ORDERCUSTOMERNAME" and "StockCutomer Name".

The fields names and values must be uppercase in both the section access table and the data model table.

I still think that concatenating both tables into a bigger fact table would simplify further developments a lot.

Re: Section Access issue with column names

Anonymous — Wed, 01 Mar 2017 10:28:29 GMT

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, STOCKCUSTOMER

ADMIN, MyDomain\satish,

USER, MyDomain\KSTL, "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

swuehl‌adamdavi3s‌stevedark‌

Re: Section Access issue with column names

Peter_Cammaert — Wed, 01 Mar 2017 10:30:34 GMT

Maybe with a different question, you'ld better start a new discussion.

Re: Section Access issue with column names

swuehl — Wed, 01 Mar 2017 11:44:33 GMT

I agree with Peter.

But maybe it's enough to enable 'strict exclusion' in document properties - opening.

Re: Section Access issue with column names

Anonymous — Wed, 01 Mar 2017 12:53:19 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

please check below link for total question swuehl‌

https://community.qlik.com/message/1222790#1222790