topic Re: problems making a linktable in QlikView

problems making a linktable

Sun, 14 Feb 2016 15:52:20 GMT

i have some problems making a linktable between to tables and that would be salesdet and customer. i dont know how to make one i have tried but failed and wonder if someone can help me out, This is for my own practice,, i would be very thankful for the help thanks

Re: problems making a linktable

Gysbert_Wassenaar — Sun, 14 Feb 2016 17:07:17 GMT

Can you try to explain the problem? I don't understand why you think you need a link table.

Re: problems making a linktable

Sun, 14 Feb 2016 17:20:46 GMT

Hello again i want to learn how to connect a link table if i have to. What i understand is that doing a link table is to erase synthetic keys and loops? but if i would do it how do i wright it in the script. i wanna learn how i work with link tables. I wanted to try it in the sales details table and the customer table.

Re: problems making a linktable

Sun, 14 Feb 2016 18:10:23 GMT

i want to try to make a link table just to see how it works. between salesdet and customer.and if i need it in the

future..all i want to know is how a make a link table and how i wright it in the script

would appriciate the help

thanks!

Re: problems making a linktable

robert_mika — Sun, 14 Feb 2016 18:58:21 GMT

Please see attached.

Re: problems making a linktable

Oleg_Troyansky — Sun, 14 Feb 2016 19:03:24 GMT

Hi,

if you'd like to understand how Qlik Data Modelling works, and how to create various data modelling scenarios, may I recommend my new book QlikView Your Business?

We also teach advanced Data Modelling at the Masters Summit for Qlik.

cheers,

Oleg Troyansky

Re: problems making a linktable

Sun, 14 Feb 2016 19:06:07 GMT

which attached file should i look at? i think it should be something to trim() with but how do i wright it in the script

Re: problems making a linktable

robert_mika — Sun, 14 Feb 2016 19:44:48 GMT

The attachment include example on how to build link table.

Regarding to your trim() question:

Could yo provide example of your script code?