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