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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple line chart - add new calculated line.

Hi!

I have a multiple line chart in QV. It has 2 dimensions and 1 expression.

Dimensions are 'Month' and 'Indicator'. Indicator can have 4 values ('A','B','C','D').

The expression is the sum of the field 'Amount' for each indicator.

And this is working OK, I have the chart with the 4 different lines displayed correctly.

My problem is:

I would like to create an additional line in the chart that displays the sum of the field 'Amount' when indicator is either ('A' or 'B'). Basically the sum of both indicators in a new different line in the chart.  Can you help me?

Thank you!!


4 Replies
settu_periasamy
Master III
Master III

May be like this..

=sum({<Indicatior={'A','B'}>}Amount)

Not applicable
Author

If I add this new additional expression maintaining the old expression, it won't show any chart. If I replace the old expression with this new one it plots 2 lines.

Do you know how to get the sum of both indicators in one line? Is it possible to plot the 2 expressions (5 lines in total) in the same chart?

Thanks!!

Not applicable
Author

Anyone?

settu_periasamy
Master III
Master III

is it possible to post the sample qvw file?.

May be you can add the A and B value sum in the Script .

Then it should shows the value like

Indicator

A,

B,

C,

D,

AB