Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
atsushi_saijo
Creator II
Creator II

The total in the chart

I have 2 same time-series, which is displayed differently.

First chart plot individual values in 3 timeseries.

Now, how could I plot the total of value in the second graph?

Error 2.jpg

I would appreciate for your feedback in advance.

7 Replies
amit_saini
Master III
Master III

Hi,

Check if this helps u:

http://community.qlik.com/message/637587#637587

Thanks,

AS

atsushi_saijo
Creator II
Creator II
Author

Hi I studied the feedbacks in the thread, but once I convert it from histogram to area chart, it loses magic. I wonder if we have option to put only total. Maybe it is impossible.

Not applicable

Hi,

You can enable the values on data points in expression tab

atsushi_saijo
Creator II
Creator II
Author

Hi, the trouble for this option is that it also shows individual values, like first diagram. We only should show total.

Error 4.jpg

israrkhan
Specialist II
Specialist II

you could have something like this, if its ok for you..

111.png

by enabling Totals on dimension limits...

22.png

atsushi_saijo
Creator II
Creator II
Author

This option was explored, but we have additional area of total, on top of individuals.

If we enable Values on Data Points, the result is below:

In this timeseries, we have dimention Year and ReCategorization (1-3rd, 4-6th ...), and Expression is just Sum(Value).

Sample data is:

atsushi_saijo
Creator II
Creator II
Author

Probably this is impossible to do. Discussed with client, and approved by adding pivot chart beneath.