Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Challenge in Creating a new field as like SECTION ACCESS field in same table

Hi ,

I have a table like below,

TEST_TABLE:
load Shipment_ID,gc_cd as COMPANYKEY,Port_Name,gc_cd as "DGF Company" Inline [

Shipment_ID, gc_cd,Port_Name

S1900012144,AE0,Dubai

S1900323233,DE0,German

S1323243243,IN0,India
S1323243243,SG0,Singaporre

];


LinkTable:
load rowno() as ID,COMPANYKEY,Shipment_ID resident TEST_TABLE;
DROP field COMPANYKEY from TEST_TABLE;

 

Now i have given the section access on COMPANY KEY and it is working fine without DGF Company field.

But when I pull the DGF Company code into the table box, I could see that the below screenshot.

I should have only one record (only record with DGF Company=IN0) but it shows 2 . how to write the code accordingly.

 
Labels (3)
3 Replies
Highlighted
Creator II
Creator II

hi,

Any responses would be great! I am still facing this issue.

Highlighted

Can you please share the section access script?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

Hi Anil,

Thank you for your response.

The script is as follows,

Load ACCESS,

NTNAME,

USERNAME,

COMPANYKEY

from Sectionaccess.xlsx;

Thanks,

Pradeep