Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

calculation sum of values in graph

Hi,

I have a table like:

date      value1  value2

1-1-12    12          1

4-1-12    11          16

7-1-12    17          12

14-1-12    12          8

etc

With this table I want to create a graph with on the X-as the date and on the Y-axis value 1 and the sum of value 2 as a straight line. So if I make a graph from 1-1-12 to 14-1-12, I want to show value 37 (=1+16+12+8) as a horizontal line from 1-1-12 until 14-1-12.

I've tried variables without success. Then I've calculated the sum of value2 in a textbox. The textbox contains the right value (37), but I can't get the value from the textbox into the graph.

any other ideas???

greetz

Per

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Try to show sum of value2 as horizontal reference line. Reference line can be defined in the Presentation tab of the chart properties window. You can give the expression Sum({1} value2) as the value of the reference line. You may have to set the static max for axis in order to see the reference line on the chart.

View solution in original post

2 Replies
Highlighted
Specialist III
Specialist III

Try to show sum of value2 as horizontal reference line. Reference line can be defined in the Presentation tab of the chart properties window. You can give the expression Sum({1} value2) as the value of the reference line. You may have to set the static max for axis in order to see the reference line on the chart.

View solution in original post

Highlighted
Not applicable

Thanx! works perfectly.

regards

Per