topic Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value in QlikView

How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a requirement where I have to plot multiple values on Y Axis for a single X Axis value. This is for a line chart. Please let me know how is this possible ? If not possible by line chart then what other chart I should use ?

I am attaching the sample data too.

I will really appreciate your help.

Regards

Ajay

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Anonymous — Tue, 12 Apr 2016 19:09:51 GMT

Hi Ajay,

Could you please provide an example about how you want to display the data.

Regards,

-- Karla

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Tue, 12 Apr 2016 19:40:43 GMT

Hi Karla,

Attaching the screenshot. This is generated in R and I have to make exactly the same in Qlikview.

Thanks for looking into it.

Regards

Ajay

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

MarcoWedel — Tue, 12 Apr 2016 19:47:01 GMT

Hi,

you could use an aggregation function like Avg() to get one expression value per dimension value.

regards

Marco

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Tue, 12 Apr 2016 19:49:10 GMT

Thanks Marco,

As per the requirement - no aggregation function is allowed. They want to see all the points w.r.t a X-Axis value. That was the first thing I offered to the business user - Avg or Max or Min.

Thanks

Ajay

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

MarcoWedel — Tue, 12 Apr 2016 20:33:32 GMT

Hi,

as you do have multiple cumulative_arc_rate values per date but only one date per cumulative_arc_rate value you could as well switch expression and dimension and use horizontal orientation instead:

or using examples I already created before your last reply:

Avg, Min and Max:

Avg with error bars

hope this helps

regards

Marco

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Anonymous — Tue, 12 Apr 2016 20:53:05 GMT

Hi Ajay,

Yes, you can do it by using line chart for both. For the first you can use BEAM_Arcrate_Arccounter.date as your dimension and an expression like the following:

=max(BEAM_Arcrate_Arccounter.cumulative_arc_rate)

The second chart should be something similar, the difference is that you must add two expressions instead of one. Please refer to the attached file. Just, that for the second chart is not really clear the calculation so the one I added are just a dummy example.

Hope it helps

-- Karla

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Tue, 12 Apr 2016 21:52:35 GMT

Thanks Karla,

I am using personal edition so I can't view your .qvw file 😞 . And I can't use any aggregation function like max or avg or min. It is required to plot all the values on Y axis.

Thanks

Ajay

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Tue, 12 Apr 2016 21:56:33 GMT

Thanks Marco,

First plot in your reply is the one which I need ? How did you make that one ? Unfortunately I can't open your qvw file as I am using personal edition.

Regards

Ajay

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Tue, 12 Apr 2016 22:59:49 GMT

Hi Marco,

When I tried to switch expression and dimension and use horizontal orientation, I got this . It doesn't show the dates too. What am I doing wrong ? If you see the X- Axis it doesn't even show the dates , it shows something else.

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

MarcoWedel — Tue, 12 Apr 2016 23:10:01 GMT

Uncheck "Force Zero" on axis tab.

Regards

Marco

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

swuehl — Tue, 12 Apr 2016 23:49:44 GMT

Another option might be a scatter chart

LOAD Date#(BEAM_Arcrate_Arccounter.date) as BEAM_Arcrate_Arccounter.date,

RowNo() as RowID,

1 as ID,

BEAM_Arcrate_Arccounter.cumulative_arc_rate

FROM

(biff, embedded labels, table is Sheet1$);

Dimensions:

RowID

Expressions:

=Sum (BEAM_Arcrate_Arccounter.date)

=Sum ([BEAM_Arcrate_Arccounter.cumulative_arc_rate])

Choose Lines&Symbols representation on presentation tab

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Wed, 13 Apr 2016 00:19:42 GMT

Thanks Marco,

I am almost there. But it is showing in reverse order .

And if I sort descending then it shows like this

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Wed, 13 Apr 2016 00:21:31 GMT

Thanks Swuehl,

I will give it a shot .

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Wed, 13 Apr 2016 02:26:43 GMT

Thanks Stefan,

I get a single line and the dates don't make any sense. I am doing something wrong because you are clearly able to get the chart.

I am attaching screenshots of other settings too.

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Anonymous — Wed, 13 Apr 2016 02:50:54 GMT

Hi Ajay,

Here is another way to plot all the values, add both fields as dimensions, this will plot by date and keep separated all the data points:

Next in your expression, add the sum of all cumulative_arc_rate:

In axis tab select contiguous

And in number select Date format for Continuous X-axis

This will produce the following output:

Regards,

-- Karla

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Wed, 13 Apr 2016 03:13:39 GMT

Hi Marco,

I was missing the setting "Continuous" . Once I checked it I got the chart :-).

Thanks a lot for all your help.

Appreciate it.

Ajay

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

Wed, 13 Apr 2016 03:14:41 GMT

Thanks Karla Appreciate it. I will try that option too.

Re: How to plot a line chart with Multiple Y Axis values for the same X-Axis Value

swuehl — Wed, 13 Apr 2016 08:38:46 GMT

Just a follow up to the scatter chart:

You need to take care that your dates are interpreted as such, having a numeric representation.

Your Excel file shows text values, AFAIR.

That's why I've used

LOAD Date#(BEAM_Arcrate_Arccounter.date) as BEAM_Arcrate_Arccounter.date,

in my LOAD script (or using your format code:

LOAD Date#(BEAM_Arcrate_Arccounter.date,'YYYY-MM-DD') as BEAM_Arcrate_Arccounter.date,

I assume that's your issue.