topic Re: Need help connecting two tables in QlikView

Need help connecting two tables

regowins — Wed, 13 Mar 2013 16:23:16 GMT

Hi,

I need help connecting two tables that have similar data. Please see attached example for more details

Thanks for your help!!

Re: Need help connecting two tables

Gysbert_Wassenaar — Wed, 13 Mar 2013 17:18:37 GMT

Rename Target_name to Target or rename Target to Target_name. Fields with the same name are used to connect tables.

Re: Need help connecting two tables

regowins — Wed, 13 Mar 2013 18:34:07 GMT

I agree it would work if Target had only a single value in it. How will it work since target has more than a single value. I need to account for the values that have more than just one value. For example, If I clicked on Event - internal I should see a count of 7 for 'P' target. Thanks!

Re: Need help connecting two tables

rwunderlich — Thu, 14 Mar 2013 01:20:43 GMT

As Gysbert suggested, rename one of the fields so the tables link.

Also use the subfield() function to generate a row for each Target value in Excel_Main:

trim(SubField(Target, ';')) as Target

-Rob

Re: Need help connecting two tables

regowins — Thu, 14 Mar 2013 18:12:19 GMT

Thanks Rob! the subfield() function was helpful. I think I can get what I want from there.