Problem with creating a chart from table

Mon, 23 Aug 2010 10:20:08 GMT

Hi,

I have a problem with creating a chart.

I have the sum of amount for each shop and month. And then I need to get the amount of first (min) month for each shop. In order to get this I use a function TOP( SUM( AMOUNT )). Everything is OK in the table. Look below:

Shop	Month	sum(Amount)	Top(sum(Amount))
A	1	50	50
A	2	20	50
A	3	40	50
A	4	60	50
B	1	500	500
B	2	960	500
B	3	580	500
B	4	430	500
C	1	260	260
C	2	120	260
C	3	60	260
C	4	80	260

The problem appears when I try to show this function in the line chart. I need to place Month on the X axis. And the chart should look like this (three straight horizontal lines):

Any ideas how to manage that?

Problem with creating a chart from table

Mon, 23 Aug 2010 10:22:50 GMT

Here is the application...

topic Problem with creating a chart from table in QlikView

Problem with creating a chart from table

Problem with creating a chart from table