Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Partner
Partner

difference between lines in graph

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!

1 Solution

Accepted Solutions
Frank_Hartmann
Honored Contributor II

Re: difference between lines in graph

see attached qvw

hope this helps

View solution in original post

3 Replies
Frank_Hartmann
Honored Contributor II

Re: difference between lines in graph

see attached qvw

hope this helps

View solution in original post

Partner
Partner

Re: difference between lines in graph

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!

Partner
Partner

Re: difference between lines in graph

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!