I'd like to create a dynamic constant line in a bar chart in PixelPerfect mode. Has anyone been able to accomplish this? I can only enter a number in the properties box. Variables are ignored. Below is just an example - I'm not looking to create an average, but to have a dynamic target line depending on the filter applied.
Solved! Go to Solution.
What does it mean dynamic constant?
My approach would be to use Combo chart with one series for bar and one series represented by line. Line would be your average. Therefore you would be able to create value for it in your source table in Qlik.
explain little bit more where the value needs to come from and i may be able to provide you with guidlines.
Thanks for reverting. I'm using the bar chart as part of a level that outputs a table. The output "table" shows both bars and numbers which is working fine. But the bar charts I'm using do only have one bar each (see design and output below). So your suggestion with another series will not work in this case because output will only be a dot instead of a line connecting several points. A combo chart only offers to option of have dots, circles, squares, diamonds, but not a vertical line. That looks a little clumsy.
So I'm hoping for a solution where I can create something like below, but make it dynamic so the constant lines get their values from a Qlik expression instead of a hard coded value.
I refered to Pixel Perfect Combo chart which has Line as well .
I will show you example in few minutes
Sorry for my poor explanation above. The combo chart does have a line. But I only have one bar => one point for the line, so it will not be able to draw the line.
so here are my steps:
one more settings - to rotate chart you need to use this option (see image below)
Thanks for the suggestion, which will unfortunately not work in my case. If you reduce your QlikView data to just one category and reload, then the red line will be reduced to a dot.
When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.