Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with creating a chart from table

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:

ShopMonthsum(Amount)Top(sum(Amount))
A15050
A22050
A34050
A46050
B1500500
B2960500
B3580500
B4430500
C1260260
C2120260
C360260
C480260


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):

error loading image

Any ideas how to manage that?

1 Reply
Not applicable
Author

Here is the application...