topic Need help with a QlikView related problem in QlikView

Need help with a QlikView related problem

Fri, 07 May 2010 08:04:39 GMT

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]

Need help with a QlikView related problem

Fri, 07 May 2010 08:50:34 GMT

Hi Dear ,

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

Cheers !!!!

Bhushan N

Need help with a QlikView related problem

Fri, 07 May 2010 09:00:14 GMT

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!

Need help with a QlikView related problem

Fri, 07 May 2010 09:43:30 GMT

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

Need help with a QlikView related problem

Fri, 07 May 2010 09:55:16 GMT

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.

Need help with a QlikView related problem

Fri, 07 May 2010 10:16:42 GMT

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.

Need help with a QlikView related problem

Fri, 07 May 2010 10:24:43 GMT

Dear ,

This is best i can provide to you rightnow.

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

Cheers,

Bhushan N

Need help with a QlikView related problem

Fri, 07 May 2010 10:36:38 GMT

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!

Need help with a QlikView related problem

Fri, 07 May 2010 12:07:51 GMT

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.

Need help with a QlikView related problem

Mon, 10 May 2010 06:52:48 GMT

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!

Need help with a QlikView related problem

Mon, 10 May 2010 09:40:51 GMT

You shouldn't try to swim against the current. It one of the basic features of QlikView that it will show you related information about a selected field or a number of selected fields.

If the user clicks the email-address QlikView will do what I would expect, show all information that is related to this email address. If you want to see details about Daniela - select Daniela.

What you probably are looking for is a click-position and retrieving other information from that row to set up your own selection values. I am not aware of such functions, maybe someone else in the forum? I was also not able to see any option to make a column a read only field (not available for selections)

Juerg

Need help with a QlikView related problem

Tue, 11 May 2010 09:49:28 GMT

Hi thanks again for your help Juerg,

i extended my table now with a new first row - ID. Each ID is related to exactly one person. The ID is unique, so when i select an ID, QlikView shows only the exactly data of one person.

I have another problem now. I'm Loop&Reduce the ID field in QV publisher for sending out reduced PDF documents. The strange thing is, that when I'm sending out a report which's recipient isn't me, the recipient recieves the same document twice. I don't know whats wrong.

Is it possible, that with the implementation of a Crosstable, the crosstable double up the data for one person?

Need help with a QlikView related problem

Tue, 11 May 2010 11:27:49 GMT

Dear ,

I dont think cross table is is duplucating data , its just a extraction of data using one of available methods.

Can you provide somemore insights about your problem with some snapshots Or Doc itself. It will be easy to diagnose .

Cheers,

Bhushan N

Need help with a QlikView related problem

Tue, 11 May 2010 11:45:44 GMT

Hi Bhushan,

I solved my problem. Our internal server contains the Email adresses for the ID's twice - one internal and one external, so the recipient get the same document twice.

Thanks for all your help guys.