topic Re: Section Access based on Island Table in QlikView

Section Access based on Island Table

sumeet-vaidya — Wed, 16 May 2018 09:08:40 GMT

Dear All,

Please help me in fixing a scenrio.I have my data model and an Island table used for selection in the frontend. I need to reduce the data based on Island field.

Kindly help.

stalwar1‌

Thanks & Regards

Sumeet

Re: Section Access based on Island Table

big_dreams — Wed, 16 May 2018 09:34:33 GMT

AFAIK, You can not reduce data using island table in script.

What is your goal? what are trying to achieve? can you explain with sample data??

Regards,

Re: Section Access based on Island Table

sumeet-vaidya — Wed, 16 May 2018 09:43:24 GMT

Hi Max,

The scenario is such that I have calling data.

User has contacted a XXX company from Call Centre 1 (Table 1)

XXX company called user back from Call Centre 2.(Table 2)

Whenever I am showing my Report, Filter should be on both the data. like if i Select Call Centre = ABC,

Data should be filtered for Contacted as well as Called so I have created an island table concatenating values of Call Centre from both the tables and using below expression.

Count({<Call Centre 1 = P(Call_Centre_Final)>} ID)

Regards

Sumeet

Re: Section Access based on Island Table

arvind_patil — Wed, 16 May 2018 10:52:31 GMT

Hi Sumeet ,

It works in My case like below

Section Access;

Load * Inline [

ACCESS, USERID, CITY

ADMIN , BA\PREDOOLE,SANGLI

ADMIN , BA\PREDOOLE1,PUNE

];

Section Application;

IslandData :

Load * Inline [

CITY

Mumbai

Pune

SANGLI];

Thanks,

Arvind Patil

Re: Section Access based on Island Table

big_dreams — Wed, 16 May 2018 10:58:29 GMT

bro it will reduce only island table. Not reduce entire document data.

Regards,

Re: Section Access based on Island Table

sumeet-vaidya — Wed, 16 May 2018 12:02:55 GMT

Hi,

Got the Solution. Data will not be reduced but It will not show up in the frontend by using P().

Thanks all for helping around.

Regards

Sumeet

Re: Section Access based on Island Table

sumeet-vaidya — Wed, 16 May 2018 12:07:43 GMT

Hi Max,

You are correct. Data wont get reduced. Its just that we need to restrict user from accessing certain Call Centres which can be done with the help of P().

Regards

Sumeet

Re: Section Access based on Island Table

big_dreams — Wed, 16 May 2018 12:17:14 GMT

glad you got the answer,

Just for my understanding how did you use p()?

Regards,

Re: Section Access based on Island Table

sumeet-vaidya — Wed, 16 May 2018 12:21:20 GMT

Hi Max,

Just as I mentioned in my previous trails.

Count({<Call Centre 1 = P(Call_Centre_Final)>} ID) ==> for Contacted

Count({<Call Centre 2 = P(Call_Centre_Final)>} ID) ==> for Called

Call_Centre_Final column added in Section Access.

Regards

Sumeet

Re: Section Access based on Island Table

big_dreams — Wed, 16 May 2018 12:26:07 GMT

cool.