topic Re: How to plot multiple series on one line graph? in QlikView

How to plot multiple series on one line graph?

Tue, 07 Feb 2012 20:36:10 GMT

Attached is a sample data file. Along the bottom would be an axis from 0 to MAX. At any point on the x-axis, it would plot three series using full accumulation: 1. The count of P1's that have the x-value or less. 2. The count of P2's that have the x-value or less. 3. The count of P3's that have the x-value of less. How can I accomplish this? Thank you.

Re: How to plot multiple series on one line graph?

swuehl — Tue, 07 Feb 2012 20:56:59 GMT

Maybe like attached?

I created a variable vMax to get the Max value of P1, P2, P3 like

=ceil(RangeMax(max(P1),max(P2),max(P3)))

Then I created a line chart with an artificial dimension

=valueloop(0,vMax,1)

and then 3 expressions:

=count(if(P1 <=ValueLoop(0,vMax,1),Key))

=count(if(P2 <=ValueLoop(0,vMax,1),Key))

=count(if(P3 <=ValueLoop(0,vMax,1),Key))

Hope this helps,

Stefan