topic Re: Notes/references on chart in QlikView

Notes/references on chart

andie_qubdata — Sun, 17 Jun 2018 10:22:34 GMT

Hi.

I want to show notes for some data on the graph. See red text in the picture. How can I do this most correctly in QlikView?

I can do it using macros with a trigger on "any selection" - move and resize transparent arrows over the chart. But this is very difficult and clears the cache.

Extension. Can I use a standard chart object and add some features to it? Or I have to create new object from the beginning?

Any other ideas?

Re: Notes/references on chart

marcus_sommer — Mon, 18 Jun 2018 13:12:31 GMT

I could imagine that you could get quite near to your screenshot with a normal combo-chart (maybe not so nice looking but transferring the information) by adding two (or maybe more) additionally dimension-values which cover the first and the last rowno() of the chart.

This means the first dimension-value is dual('% dev. rate', 1), the second until the forelast is dual(Year, Year) and the last is dual('% dev. total', 100000) to be able to sort the chart appropriate and then querying the first/last value respectively rowno() and applying the %-calculation and to layout them specially (other colors, offset, ...).

- Marcus

Re: Notes/references on chart

andie_qubdata — Mon, 18 Jun 2018 14:00:58 GMT

Do you mean something like this? Add a virtual value for dimension and draw a bar there with offset and label, and also add two expression to emitate reference lines?

Re: Notes/references on chart

vishsaggi — Mon, 18 Jun 2018 14:27:24 GMT

Can you share some sample data/file to look into?

Re: Notes/references on chart

andie_qubdata — Mon, 18 Jun 2018 15:12:14 GMT

Sorry, not yet. The picture is a screenshot from PowerPoint.

Re: Notes/references on chart

marcus_sommer — Mon, 18 Jun 2018 15:13:36 GMT

Yes, this were my thoughts.