topic Show only data related to one Table in QlikView

Show only data related to one Table

Tue, 18 May 2010 11:37:48 GMT

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]

Show only data related to one Table

Tue, 18 May 2010 12:22:07 GMT

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

Show only data related to one Table

Tue, 18 May 2010 12:40:43 GMT

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!

Show only data related to one Table

Tue, 18 May 2010 13:05:16 GMT

Hi.

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

thanks

zaman

Show only data related to one Table

Tue, 18 May 2010 13:10:18 GMT

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

Show only data related to one Table

Tue, 18 May 2010 13:14:15 GMT

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

Show only data related to one Table

Tue, 18 May 2010 13:37:02 GMT

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).