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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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...