Discussion Board for collaboration on QlikView Layout & Visualizations.
i would like to add the year to year change in percentage points to a graph like this (~ 4,3 % for 2016 and ~ 24,8% for 2017).
Is there a simple way to add this piece of information to the graph?
Thanks and Best regards
Go to Solution.
you could use the Dual() function to add this information to your expression like this:
hope this helps
Thank you very much for your rapid! and outstanding! support.
First, I copy pasted the expression into my file and adjusted it to my dimensions BUT the graph did not change accordingly. Instead the graph still looked like a regular "sum()" graph.
Then I copied the object from your attached qvw file into my sheet and adjusted the expression. It worked! I am still figuring out what I missed but I am very thankful.
Glad it helped.
Maybe you had some number format applied to your chart expression (needs to be "expression default". see number tab in chart properties).