Since you have the same field (Client) in all three connections, it is possible you could benefit from QlikView NPrinting multi-doc features: QlikView NPrinting 16 Tutorials - Multi-Document
HTH - Daniel.
Yes! That's it. Linked Field Entity between multiple qlikview sources. The tutorial you linked me actually goes as far as connecting multiple qvws to a report. But at the end, it links to another tutorial about how to setup a linked field entity between themultiple connections. (Year on one qvw and sales year on another qvw in the case of their example, client in the case of my need.) The linked field entity can be used to setup either a union join (all values on all sides) or an inner(?) join (only the intersection of values that exist on all sides) of the field the qvws have in common.
That said, I've already finished channeling the last few data points to the one qvw and probably would've had to for other reasons anyway (it's shaping up to be a sleeker 'version 3' of a large 'version 2' dashboard.) If the source data for the qvws isn't just the same database, but includes flat files and such, you'll want to comb through and make sure the field values in the linked field entity are consistent across the qvws too For instance, one dashboard had client ACME and another had Acme, and I was writing mapping tables to reconcile those kinds of differences between the respective qvws.
Other likely case for consolidating to a single dashboard might be if 70% of your clients use TemplateA, 19% use TemplateB, 1% use TempateC and 10% don't need a report. I think I will be creating flag fields for the different templates to identify which clients I want to use template a, b, c. Then on the three reports I make, I'd have the first cycle through the clients present on the TemplateA field's list, then the second report cycle through clients on TemplateB. I'd use the actual clientnames in the values for the template fields, so they can come through in the field value position on the report's file name.
Example Client nprinting report Template flag table:
Client TemplateA TemplateB
And cycling through TemplateA field values would produce reports for Acme and Bacme, while cycling through TemplateB field values would produce reports for Widgetco and Something. And no report would be generated for client Another. At least, I hope that will work out when I do it. It should. (Reporting team gave me a list of which clients need this same 12 metrics, and which clients need these other 10 metrics, and which clients need these other 30 metrics. And I will be making one template for each group of clients.)