topic Re: DOTS ABOVE EACH BAR in QlikView

DOTS ABOVE EACH BAR

Sun, 15 Nov 2015 02:53:42 GMT

I have a Combo chart in which I want to use Bars for the Actuals and Dots on each bar for Expected . There is is Bar for Each Quarter so I would like to see Dots for Expected above the respective quarter.

But if you notice all the dots are stacking up on 2nd Bar

What I am doing wrong here ??

Re: DOTS ABOVE EACH BAR

sunny_talwar — Sun, 15 Nov 2015 02:55:21 GMT

May be use error bars to add a line instead of the dots -> Bar chart target lines in QlikView The Qlik Fix!

Re: DOTS ABOVE EACH BAR

petter — Sun, 15 Nov 2015 07:31:31 GMT

Actually the TRELLIS option (a button) under the dimensions tab is what you need here. Have a look at this:

Trellis let you have many charts to be laid out in a grid. This makes each chart contain only one dimension in your case and make the symbol option work correctly for your purpose.

Re: DOTS ABOVE EACH BAR

Sun, 15 Nov 2015 19:32:42 GMT

Can you pls attach a qvw?

Re: DOTS ABOVE EACH BAR

petter — Sun, 15 Nov 2015 20:08:06 GMT

The QVW has been attached already.... can't you see it?

Re: DOTS ABOVE EACH BAR

Sun, 15 Nov 2015 20:31:38 GMT

Thanx for the QVW, it looks like its gonna work, but I need to create the Quarters and they are cumulative quarters, so If I select <=Mar , then I will see only 1 bar 'Q1', if I select for example May, I wanna see Bar for 'Q1' and bar for 'Q2' .

I have Year and Month dimensions. How can I do that

Re: DOTS ABOVE EACH BAR

petter — Sun, 15 Nov 2015 20:48:12 GMT

This is sort of a new question... were you happy with the first solution?

Re: DOTS ABOVE EACH BAR

Sun, 15 Nov 2015 20:51:23 GMT

Yes that is a good solution

Re: DOTS ABOVE EACH BAR

petter — Mon, 16 Nov 2015 05:11:22 GMT

Please mark the question as answered then - so this thread is closed