Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Hopefully, there is a way to fix my current problem.
I have multiple tables in an application and for one straight/pivot table I need to show information related to two different tables in one row.
For example
HID | CostID | OpenDate | ActionDate | Cost | Completeddate | ActualCost1 | ActualCost2 | ReceivedBy |
10 | 1 | 26/03/2015 | 08/04/2015 | 100 | 01/01/2015 | Mr A | ||
20 | 2 | 24/03/2015 | 08/04/2015 | 200 | 02/01/2015 | Mrs B | ||
30 | 3 | 19/03/2015 | 08/04/2015 | 300 | 03/01/2015 | Mr C | ||
40 | 4 | 23/04/2015 | 27/04/2015 | 400 | 04/01/2015 | Mrs D | ||
- | - | - | - | - | - | 50 | 30 |
HID is one dimension and CostID is another dimension. Open date to completed date are all expressions that use data from one table with data related to HID.
ActualCost1 and ActualCost2 use information from a second table.
I want the cost of 50 and 30 to show on the row for the related CostID rather than show on a row with blanks which isn't useful.
Is there any way to get this work?
Thanks
The issue is with your join on your 2 tables.
As long as CostID is present in both your tables Qlik will join on CostID automatically and fix your issue.
If there is no direct join you will need to use Set Analysis on your expresssions to join the values yourself.
I suggest that you post your qvw or a sample with the issue. But i agree with andy.weir, this is a data model problem.
If the data is being displayed like this it means that the two tables aren't associated properly - how they are linked?
Thanks for all the responses. I'll see if I can post the qvw.
It does seem like the tables aren't properly associated