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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

Need assistance

Hi there,

table1:

LOAD DISTINCT
NTNAME,
ACCESS,
ACCESSDETAIL
RESIDENT UserList;

Table2:

Load distinct SecuredOrgAccessAttribute,[Ward/Location] resident WardwithFlag
where securorgatt <> 1

I want in the third table3 , like 

ANY Other clinics

LOAD DISINCT NTNAME,Organisation as SecuredOrgAccessAttribute

where securorgatt <> 1;

I am unable to fetch the NTNAME other clinics .

Showing null -

ashmitp869_0-1655425600126.png

 

Labels (2)
0 Replies