topic Multiple line chart - add new calculated line. in QlikView

Multiple line chart - add new calculated line.

Thu, 03 Sep 2015 14:05:38 GMT

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!!

Re: Multiple line chart - add new calculated line.

settu_periasamy — Thu, 03 Sep 2015 14:21:02 GMT

May be like this..

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

Re: Multiple line chart - add new calculated line.

Thu, 03 Sep 2015 18:48:50 GMT

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!!

Re: Multiple line chart - add new calculated line.

Mon, 07 Sep 2015 08:07:11 GMT

Anyone?

Re: Multiple line chart - add new calculated line.

settu_periasamy — Mon, 07 Sep 2015 08:11:40 GMT

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