Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

Problems with table join - i think


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?

Jo

EastWestNorthTotal
month/previousMonthmm-yymm-yymm-yymm-yymm-yymm-yymm-yymm-yy
DemandNew Leads"new enquiries
LeadsPlustestdrive
New Carscars sold
AccessTime 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
0 Replies