Issues with LinkTable

[bmenicucci]

trafficstars

Hello Rob, I need your help as I don't understand why the heck these two tables are not linking correctly. I have a facts table which I'd like to link to Calendar using QVC.LinkTable routine, but it looks there's something preventing it to happens.😵 Enclosed you'll find a sample application. Any suggestion or hint will be highly appreciated! Test_kpi.qvw.zip

Thanks, Brunello

[RobWunderlich]

The Qvc.LinkTable routine, as coded, requires that each call use the same fields. You are generating two different key values because you are using two different field lists.

CALL Qvc.LinkTable('LinkTable','Calendar','KeyCalendar'); CALL Qvc.LinkTable ('LinkTable','KPILavorazioni','KeyKPILav,KeyCalendar');

I'm not clear on why you need a link table to link to the calendar?

Kind Regards, Rob Wunderlich

http://MastersSummit.com @QlikMasters http://QlikviewCookbook.com @QVCookbook http://www.easyqlik.com QViewer

On Fri, Apr 17, 2020 at 6:21 AM Brunello Menicucci [email protected] wrote:

Hello Rob, I need your help as I don't understand why the heck these two tables are not linking correctly. I have a facts table which I'd like to link to Calendar using QVC.LinkTable routine, but it looks there's something preventing it to happens.😵 Enclosed you'll find a sample application. Any suggestion or hint will be highly appreciated! Test_kpi.qvw.zip https://github.com/RobWunderlich/Qlikview-Components/files/4493150/Test_kpi.qvw.zip

Thanks, Brunello

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/RobWunderlich/Qlikview-Components/issues/93, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABOOPBFMIEETM5F7DJ343ETRNBJT5ANCNFSM4MKXWP3Q .

[bmenicucci]

Ok, in that case I was completely misusing the subroutine: my understanding was that I could generate a LinkTable for all the Keys I needed. Thus, in the sample I have a lot of tables but these two particular ones weren't correctly linked... now I see why Sorry, my fault 🙏

On Fri, Apr 17, 2020 at 5:21 PM RobWunderlich [email protected] wrote:

The Qvc.LinkTable routine, as coded, requires that each call use the same fields. You are generating two different key values because you are using two different field lists.

CALL Qvc.LinkTable('LinkTable','Calendar','KeyCalendar'); CALL Qvc.LinkTable ('LinkTable','KPILavorazioni','KeyKPILav,KeyCalendar');

I'm not clear on why you need a link table to link to the calendar?

Kind Regards, Rob Wunderlich

http://MastersSummit.com @QlikMasters http://QlikviewCookbook.com @QVCookbook http://www.easyqlik.com QViewer

On Fri, Apr 17, 2020 at 6:21 AM Brunello Menicucci < [email protected]> wrote:

Hello Rob, I need your help as I don't understand why the heck these two tables are not linking correctly. I have a facts table which I'd like to link to Calendar using QVC.LinkTable routine, but it looks there's something preventing it to happens.😵 Enclosed you'll find a sample application. Any suggestion or hint will be highly appreciated! Test_kpi.qvw.zip < https://github.com/RobWunderlich/Qlikview-Components/files/4493150/Test_kpi.qvw.zip

Thanks, Brunello

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/RobWunderlich/Qlikview-Components/issues/93, or unsubscribe < https://github.com/notifications/unsubscribe-auth/ABOOPBFMIEETM5F7DJ343ETRNBJT5ANCNFSM4MKXWP3Q

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/RobWunderlich/Qlikview-Components/issues/93#issuecomment-615304829, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACIMURKBQXEHSJKGJS3JH6DRNBXV7ANCNFSM4MKXWP3Q .