Show only data related to one Table

[#1]

Hi,

I've attached a "Test QV.zip" file which contains a folder with a QlikView Document named "Test.qvw" and the data needed to reload it.
Also I attached a "Userlist.xls", which contains the relevant data I need.

I loaded the "Userlist.xls - TAB Userlist" in my QlikView Document. Also I loaded the "TAB - Tutorial.qvw" in my Document.
These two tables are joined via the ID-field.
What I want to do now, is, that only the datas from the "TAB-Tutorial.qvw" are showing in my QlikView Document.
I need a table, which is only showing the data from the Tutorial.qvw TAB in the Excel Userlist.

Because of the ID field, QlikView is showing me all data from all two tables in the ID field.

So, how can I reduce the data, that only the ID's from the Tutorial.qvw TAB are showing up?

I thought a WHERE statement can solve my problem, but I don't know how the right syntax is in QlikView.

Maybe:

LOAD ID,
 User
FROM
[...\Userliste.xls]
(biff, embedded labels, table is Tutorial.qvw$)
WHERE ID (Userlist) = ID (Tutorial.qvw);

I hope you understand my problem.

Thanks for help!

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1563.Test-QV.zip:550:0]

[#2 · Accepted solution]

Hi

Use this script:

Reduce:

LOAD ID,

User

FROM

(biff, embedded labels, table is Tutorial.qvw$);

left join LOAD ID,

ADName,

Domain,

F.Name,

L.Name

FROM

(biff, embedded labels, table is Userlist$);

Thanks

zaman

[#3]

Hi zaman,

thanks for your help.It's working, but in the ID table, all ID's are listed again. Is it possible, that only the ID's are listed, which are related to users.
Please have a look at the Tutorial.qvw sheet of the Userlist.xls.
Here you can see, that ID 1 only can see data of Rob.
So, I need a table in QlikView, which only is showing the ID's, which are related to a user.

ID User
1 Rob
3 Sally
7 Joe
9 Sally
10 Joe

Thanks!

[#4]

Hi.

I don't understand what do mean? can u please show me on excel what u wants?

thanks

zaman

[#5]

I have downloaded the application and done like zaman suggested .I am getting output as you required. Table is only showing id's which are related to users.

Probably you might have loaded userlist table first and left joined with Reduce table.In that case use Right join instead of Left Join

[#6]

Please download my application and reload. i think u will get correct result.

[#7]

I cant get the result.
First I changed the paths in the script for the userlist and performed a reload. It looks like the following now.

What I have exactly to do, to get the data I want (only ID's who are related to a user).