Link table suggestion

Dwyane — Fri, 02 Apr 2021 11:21:54 GMT

Hello,

I would like some help and suggestions on how to design my link table. This is my scenario

I have table 1 which is expected sales by month and this has the fields Month, Year, Product Line and expected sales. Table 2 is a customer table which has month, product line and actual amount brought for that month. What can be combined together is month, year and product line from both tables.

I would like to create a one chart that so when the user selects a product line a and year the chart displays the expected sales amounts, actuals by customers by month for that year . So the X axis is Month and below the X axis I would like the customers in different colours all plotted on one chart the Y axis is expected and actual amount.

I know Will does not support two dimensions in a chart so how would I do this? Thank you

topic Link table suggestion in QlikView

Link table suggestion