topic Straight Table issue with dimensions and expressions from different tables in QlikView

Straight Table issue with dimensions and expressions from different tables

Thu, 20 Aug 2015 07:49:22 GMT

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

Re: Straight Table issue with dimensions and expressions from different tables

ogster1974 — Thu, 20 Aug 2015 07:54:04 GMT

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.

Re: Straight Table issue with dimensions and expressions from different tables

jonathandienst — Thu, 20 Aug 2015 08:31:01 GMT

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.

Re: Straight Table issue with dimensions and expressions from different tables

kuczynska — Thu, 20 Aug 2015 09:25:35 GMT

If the data is being displayed like this it means that the two tables aren't associated properly - how they are linked?

Re: Straight Table issue with dimensions and expressions from different tables

Thu, 20 Aug 2015 10:12:17 GMT

Thanks for all the responses. I'll see if I can post the qvw.

It does seem like the tables aren't properly associated