topic Re: Get link value from Section Access in QlikView

Get link value from Section Access

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

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, LINK

ADMIN, admin, *

USER, user1, UK

USER, user2, US

USER, user1, SPAIN

];

SECTION APPLICATION;

DATA:

LOAD * INLINE [

COUNTRY, SALES,LINK

USA1, 150,US

United Kingdom, 250,UK

Spain1, 350,SPAIN

India1, 350,INDIA

];

From the above data the section access and section application is linked by LINK column.

Is it possible to get the LINK value.

For e.g. When "user1" access then the LINK UK,SPAIN can set to loaded to another table/variable.

Re: Get link value from Section Access

rwunderlich — Mon, 28 Aug 2017 20:18:40 GMT

=concat(DISTINCT LINK, ,',')

-Rob

Re: Get link value from Section Access

Anonymous — Wed, 30 Aug 2017 08:40:44 GMT

Thanks for reply.

One question, Can I use this as follows in script

I need that if the LINK value matches in resident Table2 then show value else show '*'. Means I need to display all the records in resident Table2, but LINK column should display '*" where it does not matches with =concat(DISTINCT LINK, ',')

Noconcatenate

Table1:

LOAD

FirstName,

LastName,

Link

resident Table2

Re: Get link value from Section Access

rwunderlich — Wed, 30 Aug 2017 14:23:08 GMT

You can't do this kind of matching in script because the LINK value is set per user at runtime. Also, if you are using "Initial Data Reduction based on Section Access", the non-matching rows won't exist for the user.

Are you using data reduction?

-Rob

Re: Get link value from Section Access

Anonymous — Wed, 30 Aug 2017 15:26:05 GMT

I want to display non-matching rows but the values should be '*' instead on actual value.

Re: Get link value from Section Access

rwunderlich — Wed, 30 Aug 2017 16:15:20 GMT

Are you using "Initial Data Reduction based on Section Access"?

Re: Get link value from Section Access

Anonymous — Wed, 30 Aug 2017 16:18:11 GMT

In my document there is following setting

Setting —> Document Properties -> Opening tab -> “Initial data reduction Based on Section Access” and “Strict Exclusion”.

Both “Initial data reduction Based on Section Access” and “Strict Exclusion” are checked

Re: Get link value from Section Access

rwunderlich — Wed, 30 Aug 2017 16:27:59 GMT

When using “Initial data reduction Based on Section Access” non-matching rows are removed from the data. So in your original example, the row

India1, 350,INDIA

simply does not exist for user1. There is no way to display it.

What you can do is load "*" versions of the rows and link those with the LINK key the user has. That's an interesting approach I haven't tried.

-Rob

Re: Get link value from Section Access

Anonymous — Wed, 30 Aug 2017 17:00:47 GMT

=concat(DISTINCT LINK ,',')

is it possible to create the Mapping table (inline) from the above statement in script