Need help with a QlikView related problem

[#1]

Hi all,

I attached a Zip-file which contains the QlikView Document and the tables, which are needed to help me in this case.
Please open the Tutorial_Userlist.qvw and go to the TAB "Userlist". Here you can see a table which contains the Names of the Users, the Email address of the Users and the Data, which they should see.

Please open the "Main" TAB. Here you can choose the employee. If you select one or two, you only see the data related to the selected employee/employees.Now, please go back to the "Userlist" TAB. Here the logic should be the same. For example, when I select Roland Schaeffer in the table, the qlikview Document should only show the data for Joe and Sally (they have a 1 in the table, Rob is NULL. Another Example: When I select Daniela Reiter the QlikView Document should only show the data related to Rob and Sally or when I select Stefanie Spangler in the table the Document should only show the data from Joe - Joe has a 1 in the line from Stefanie, Rob and Sally NULL.)

How can I do this? Is this achivable?

Thanks for your help in this case.

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

[#2 · Accepted solution]

Hi Dear ,

Please see attached & let me know this is what you are looking for ?

Cheers !!!!

Bhushan N

[#3]

Hi bnirgude!

Yeah, thats exactly that, what I need.

BUT - i don't understand what you exactly did.
Can you please explain me step by step how you achieved this?

Thank you very very much for your great help in this case!

[#4]

Dear ,

Your "Copy of Userliste_test.xls " table is cross table , so I loaded using crosstable option .

Also there are few unnecessary links "F8" which i corrected . Remember, qlikview will not ask you & it will form association with columns having same name .

You can use table viewer to see the association i made.

Always welcome for any further communication.

Cheers,

Bhushan N

[#5]

Ok, thanks.

But I don't understand what I have to do, to load this as a crosstable.
Would be very pleased if you can make a short description what steps you did, to achieve this result.

Thanks in advance.

[#6]

Your load statements should be preceeded by a label to make your life easier with the data. You have "Directory;" above your loads which is not really doing anything. Look at Bhushan's load script where he added labels like "Datentabelle:" etc. When you create new objects you can then limit the fields to one of your tables by a meaningful name. The labels need to end with ":", this will also format them automatically to Italics:

Your naming is a bit difficult but you seem to have Employees (Joe, Rob, Sally) and users (e.g. Roland Schaeffer). Note that Bhushan however made your Employees to "user" and your users to F.Name and L.Name. Your sheet "Tutorial" shows the relation between Employees and users as a matrix. With your script you created fields for each of the employees but to make connections in QlikView your field names need to match to create a link between the tables. With the Crosstable load that Bhushan created you get now a record for each combination of Employee and User (Look at Tables Loaded in documents, bottom table). Now selecting a User impacts all other tables containing the same field name.

[#7]

Dear ,

This is best i can provide to you rightnow.

Try to experiment with the same & you will get your answer.

Cheers,

Bhushan N

[#8]

Thanks for your reply.
Now, I understand the relations between the fields.

What I don't understand is the Crosstable load:

Userliste_test:
CrossTable(User, Data, 4)
LOAD * FROM
[Copy of Userliste_test.xls]
(biff, embedded labels, table is Tutorial$)
WHERE(not IsNull(Joe) OR not IsNull(Rob) OR not IsNull(Sally) AND not IsNull(Email));

See line 2 - why I use "User, Data, 4" for the Crosstable load?
How I can achieve such an crosstable load with the File Wizard / Prefix - Crosstable, such as birngude did it in the Tutorial_Userlist.qvw. What steps are able to perform?

Thanks for your help guys!

[#9]

the 4 specifies the number of fields to "skip" when looking for the matrix.

The first parameter (User) specifies the field that contains the matrix column name while the second parameter (Data) specifies the field for the cell value. In the resulting table the skipped fields and the matrix evaluation get joined.

I am not aware of a crosstable load wizard.

[#10]

Thanks for your explanation Juerg.

I'm having another problem now. In the TAB "Userlist", when clicking on the Email field of (i.e.) Daniela Retier, QlikView shows me all Users, with the same Email address. What I want to have is, that when I select the Email address of (i.e.) Daniela Reiter, QlikView should show only the data related to Daniela Reiter and not all Users, with the same Email address.

How to do that?
Thanks for help!