Trend line

[#1]

I'm trying to combine two tables in one diagram. The tables go something like this.

Table1:

Customer	Month	Sales
Customer1	1	180
Customer1	2	230
Customer1	3	280
Customer1	4	170

Table2:

Customer	Trend per Month
Customer1	120

Now I would like a graph over a year with the results of the both tables in one diagram. The second table should show a horizontal line over the whole year. Something like this.

There probably is a simple solution, but I can't find it at the moment.

[reddy-s]

Hi Voornaam,

That is the default behaviour in Qlikview and Qliksense. Once you make a selection, the engine logically makes associations and shows all the possible values in white colour. This is how it has to be in the case of listbox or any field for selection.

But if you need to show a measure which only gives the sum of sales for customer 1 for all the months, use an expression like this as your measure: sum( {$< Customer = {"Customer 1"} >} sales)

If you need the sum of sales for month 1 for all the customers then use the following expression: sum({< Month = {1}  >}sales)

This way you can make calculations on the subsets you like to.

Hope this explains your problem.

- Sangram

[#3]

This is not the solution I'm looking for. Although it's a good program, I don't think it will get me the graphs the way I want them.

Anyway, thanks very much for trying to help me.