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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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