topic Re: OverLaping of Numbers in chart in QlikView

OverLaping of Numbers in chart

Thu, 11 Dec 2014 19:49:16 GMT

I have revenue and GP% in a chart, as you can see below both the numbers are overlapping. Can some one please let me know if there is some kind of property to not make this numbers overlap.

Re: OverLaping of Numbers in chart

Anonymous — Thu, 11 Dec 2014 20:02:42 GMT

not really...but there are a couple of work arounds

you could try checking Plot Values inside Segments in Presentation tab - will still have overlaps for some selections...or check Text on Axis for the bar chart - this will eliminate the overlap but some clients may not prefer this. but if the data points are close like in your screenshot, the numbers will overlap.

Re: OverLaping of Numbers in chart

Anonymous — Thu, 11 Dec 2014 20:11:04 GMT

Hi,

You can remove values for revenue by unchecking value on data points checkbox under expression tab.

user can know revenue value when he hovers on the bars,so will have only GP % will be displayed,this is one solution.

Regards

Neetha

Re: OverLaping of Numbers in chart

Thu, 11 Dec 2014 20:14:45 GMT

Hi Harry,

check the value on data points in expression tab and plot value segment in presentation tab for every expression

Re: OverLaping of Numbers in chart

kamal_sanguri — Thu, 11 Dec 2014 20:20:32 GMT

Try using selecting the log scale for one of the expression in 'Axes' Tab.

Re: OverLaping of Numbers in chart

Thu, 11 Dec 2014 20:52:51 GMT

Thanks kamal sangur most of the numbers are not overlapping after checking the Log Scale.

Re: OverLaping of Numbers in chart

kamal_sanguri — Thu, 11 Dec 2014 20:55:29 GMT

If helped..can u please mark this question as answered.. Thanks