search

RobWunderlich / Qlikview-Components

A library for common Qlikview Scripting tasks
197 stars 98 forks source link

Issues with LinkTable #93

Closed bmenicucci closed 1 year ago

bmenicucci commented 4 years ago

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 commented 4 years ago

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 notifications@github.com 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 commented 4 years ago

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 notifications@github.com 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 < notifications@github.com> 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 .