Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Does anyone know if QV offers the option to show the difference beetwen two lines in a graph?
The idea is to display as lines the actual values of the field while, dinamically, the graph is showing the bars with the difference between both lines as well.
I couldn't find anything like this and I suspect it is not supported by the tool.
I'm posting a photoshopped layout of the expected result (dummy values of course). The first bar displays the difference between the revenue of both projects in 2019 (4 units) and so does the second one for 2020 (7 units).
Thanks!
see attached qvw
hope this helps
Thank you Frank, but the problem I faced is doing that same graph that you posted (thanks again!) without having to hardcode the values of the projects, since the user will have to be able to select two of their choice.
Maybe merging your proposal with the use of getfieldselections() will do the trick.
I'll try and let you know if it worked.
Thanks!
That's it!
I had to define two variables because the expresions didn't work directly on the graph.
I attach the qvw.
Thanks a lot Frank!