Problems with table join - i think

josephinetedesc — Wed, 13 May 2015 06:25:51 GMT

Hi All

1. the original table - this has 9 columns (one of which is a calculated column)

2. The comment table - this has 3 columns

Problem 1:

where should I do the calculations so tht the comments align as shown: I realise that the 3rd column is where I can use an expression.

Problem 2:

Time to Test drive for FORDS - 2 days is very good and 14 days is good (so when reporting "good" results it is all days between 0 and 14) - so some FORDS cars can be both good and very good.

Would it be best to do one flat table - I suppose that would work best?

			East		West		North		Total
	month/previousMonth		mm-yy	mm-yy	mm-yy	mm-yy	mm-yy	mm-yy	mm-yy	mm-yy
Demand	New Leads	"new enquiries
	LeadsPlus	testdrive
	New Cars	cars sold
Access	Time to test drive	<2 days FORDS -VeryGood
	Time to test drive	<14 days FORDS - Good
	Time to test drive	<14 days Mazda Very Good
	Time to test drive	<28days Mazda Good

topic Problems with table join - i think in QlikView

Problems with table join - i think