Joining a Crosstable Field with data table from database

[#1]

Hi,

I have another problem with QlikView.
Please see the attached .rar file and open the QlikView document.

I created a excel table with user information and a Excel Table with Sales Area information.
In QlikView I integrated the two tables in the attached document.
The Userlist is integrated as a crosstable, to work properly for my needs.

Problem is, that I need to connect the two tables across the "Sales Area" field.
But everytime i rename the Crosstable field "SalesArea" into "Sales Area" QlikView shows me an error (Load inline error).

So, how can I join the crosstable with the other table?

I really need help with this.
Thanks in advance.

Regards
Andreas

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7585.Crosstable-Join-Problem.zip:550:0]

[#2 · Accepted solution]

Hi Hofbauer,

I went through you application and the data you have given in the post. I hope I understood your problem. What you have tried is correct. But in the first table you have used "Sales Area" as the field value and while doing the Cross table you are using SalesArea as the field name. So they dont match. But when you change thename of field "SalesArea" in the Cross table to "Sales Area" you have to provide a square bracket along with it. This will help you sove your problem. I have used it in my system and it is working perfectly in my system. what you have to do is:

Cross Table([Sales Area],Data,4)

Laod * from utilities.xls

hope this helps you

Thanks Joseph.......

[#3]

Hi Joseph,

thank you very much for your help.
It's working now!