Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Ajay,
Could you please provide an example about how you want to display the data.
Regards,
-- Karla
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
Hi,
you could use an aggregation function like Avg() to get one expression value per dimension value.
regards
Marco
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
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
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
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
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
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.