topic Re: BAR CHART ISSUE in QlikView

BAR CHART ISSUE

Tue, 17 Nov 2015 01:27:19 GMT

Attached are the Dashboard, QVD and the issue image.

I have a Bar Chart with ValueList dimension and I am shoing 4 Quarters. Each Quarter is a bar.

Then for each Quarter I have an expected value which I wanna show as a Line above each Bar.

Right now I am showing the expected as circles but they are not working either .

Please see the attached image I would like to accomplish

Re: BAR CHART ISSUE

swuehl — Tue, 17 Nov 2015 01:41:30 GMT

Please try to avoid posting multiple times the same request, which makes it hard to follow a discussion.

what about the solution shown in your other thread?

https://community.qlik.com/thread/191626

Re: BAR CHART ISSUE

Tue, 17 Nov 2015 01:49:43 GMT

That solution didnt work, I attached the Dashboard , QVD and the Image. Can you please help me out with that

Re: BAR CHART ISSUE

swuehl — Tue, 17 Nov 2015 11:20:21 GMT

'Didn't work' is not very helpful.

There was an issue with the negative / positive signs of the error bars calculation, I've corrected that in attached sample.

Re: BAR CHART ISSUE

Tue, 17 Nov 2015 14:29:28 GMT

Thanx for the resolution. One last thing is when I select Oct or Nov its great but when I select months less then Oct, like Mar or April, Error Bars are messed up .

Any Suggestions

Re: BAR CHART ISSUE

swuehl — Tue, 17 Nov 2015 15:34:01 GMT

Seems like the error bars are messing up the automatic scaling when the error bar position is much lower than the bar height (like for the first few months).

I've added a custom max axis scale calculation to fix this, you might need to adapt this to your data as appropriate.

Re: BAR CHART ISSUE

Tue, 17 Nov 2015 16:10:52 GMT

Still the same result and is there a way to see values of error bars as pop up?

Re: BAR CHART ISSUE

swuehl — Tue, 17 Nov 2015 17:02:56 GMT

Could you describe a bit more detailed what the issue is?

With the latest QVW, I see this for March / April:

Seems quite ok to me.

If you want to see the expected values, you can either use a straight table chart as in my sample, or create another expression with only 'text as pop up' display option enabled.

Re: BAR CHART ISSUE

Tue, 17 Nov 2015 17:12:43 GMT

if u see that the orange bar has the line at the bottom why is that??

Re: BAR CHART ISSUE

swuehl — Tue, 17 Nov 2015 17:39:46 GMT

Look at the lower straight table. That's what your 'Q2 Expected' expression returns.