Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Section Access on 2 Columns

Hi Every1,

I need your help.. 🙂

please find attached the excel input data file for section access.

Prj_No

Task_No

Manager

Executive

Amt

1101

1

SRINI

MANISH

100

1101

2

SRINI

MANISH

110

1101

3

SRINI

SACHIN

120

1102

1

MANISH

SRINI

210

1102

2

MANISH

SRINI

220

1102

3

SACHIN

RAHUL

230


i have already implemented section access on Column "EXECUTIVE" i.e, if i select MANISH then already my section access is working fine but i have another requirement.

If i select any Executive then i need to search the same value in the MANAGER Column & show the relavant amounts because the executive can also be a Manager on the same or on different project codes.

Section Access to be implemented on Manager and Executive (2 Columns)

For example.,

If NTUSER "MANISH" logs in then it should search for this value in MANAGER column and show me the output as below

1102

1

MANISH

SRINI

210

1102

2

MANISH

SRINI

220

in the same way another NTUSER SRINI log in then his actual amount as a executive is coming fine but i also want to show the values as a manager & the output should be as below.

1101

1

SRINI

MANISH

100

1101

2

SRINI

MANISH

110

1101

3

SRINI

SACHIN

120


Need your help & suggestions for the same.. 🙂

Thanks in Advance..

Rgds,

srini

10 Replies
Not applicable
Author

Hi All,

 

I would like to thank you all for your valuable Suggestions,

I have got the Solution.

First I have Loaded the resident of the Same Table Twice but in First Resident load only the Manager Name & in second Resident Loaded Table load only the Executive Name and concatenate both the tables.

It will result in a common Name which can be used for comparison for any number of Expressions.

ForExample:

For First Expression i can Say if(ExecutiveName = CommonName,Amt)

For Second Expression -- if(ManagerName=CommonName,Amt)

The script will Look Like below---

MainTable:

Load

Project_No&'-'&Task_No as CommonLink,

Project_No,

Task_No,

Executive Name,

ManagerName,

Amt

from ExcelFile.Xls;

CommonTable:

Load

Project_No&'-'&Task_No as CommonLink,

ExecutiveName as CommonName

Resident MainTable;

 

concatenate

 

Temp:

Load

Project_No&'-'&Task_No as CommonLink,

ManagerName as CommonName

Resident MainTable;

I am able to get a CommonName & using Set Analysis i am able to achieve my output.

Thanks again for all your Suggestion but still i am looking at the Performance on a Hight Data Volumes.

  

Rgds,

Srini