topic Joining a Crosstable Field with data table from database in QlikView

Joining a Crosstable Field with data table from database

Wed, 12 May 2010 09:00:09 GMT

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]

Joining a Crosstable Field with data table from database

Wed, 12 May 2010 09:19:45 GMT

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

Joining a Crosstable Field with data table from database

Wed, 12 May 2010 09:36:15 GMT

Hi Joseph,

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