topic Re: difference between lines in graph in QlikView

difference between lines in graph

jreinagi — Sat, 16 Nov 2024 02:55:12 GMT

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!

Re: difference between lines in graph

Frank_Hartmann — Wed, 24 Jul 2019 09:53:40 GMT

see attached qvw

hope this helps

Re: difference between lines in graph

jreinagi — Wed, 24 Jul 2019 10:01:47 GMT

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!

Re: difference between lines in graph

jreinagi — Wed, 24 Jul 2019 10:35:38 GMT

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!