topic Re: Stopping values on data points overlapping in QlikView

Stopping values on data points overlapping

Anonymous — Mon, 08 Sep 2014 14:59:15 GMT

Is there a way to stop values on data points from overlapping in combo charts? I have a number of charts where I'm showing the value on data points but often the data values overlap each other. Is there a feature in Qlikview that automatically finds the best position for the value on the data point to avoid overlap?

Thanks

Greg

Re: Stopping values on data points overlapping

MK_QSL — Mon, 08 Sep 2014 15:05:28 GMT

Go to presentation tab

Values on Data Point

Select Vertical....!

Re: Stopping values on data points overlapping

Anonymous — Mon, 08 Sep 2014 15:10:23 GMT

Thanks Manish but it is a different kind of overlap. Please see image below as example -

Re: Stopping values on data points overlapping

MK_QSL — Mon, 08 Sep 2014 15:16:53 GMT

You can do some trick like below

1) Your First Expression - Keep as It is

2) Your Second Expression - Change as below

Dual(Chr(10)&Chr(10)&Chr(10)&Chr(10)&YourSecondExpression,YourSecondExpression)

Try it and let me know if this is helpful or not...

UPDATE:

Give some different Text Text Format ('<B>') and Text Color (RED()) to 2nd Expression values...

Re: Stopping values on data points overlapping

Anonymous — Mon, 08 Sep 2014 15:32:11 GMT

Thanks Manish but I'm not sure I understand. I'm new to programming and Qlikview.

Re: Stopping values on data points overlapping

MK_QSL — Mon, 08 Sep 2014 15:34:52 GMT

You definitely having two expressions...

Keep First Expression as it is

and Replace the second expression as below

Dual(Chr(10)&Chr(10)&Chr(10)&Chr(10)&(YourSecondExpression),(YourSecondExpression))

Wherever YourSecondExpression is written, replace with your original expresison...

If your expression is something like SUM(Sales)/SUM(Total Sales), you have to use as below

Dual(Chr(10)&Chr(10)&Chr(10)&Chr(10)&(SUM(Sales)/SUM(Total Sales)),(SUM(Sales)/SUM(Total Sales)))

Re: Stopping values on data points overlapping

Anonymous — Mon, 08 Sep 2014 15:40:46 GMT

Tried that. No impact. Looks the same as before.

Re: Stopping values on data points overlapping

MK_QSL — Mon, 08 Sep 2014 15:43:05 GMT

Can you provide some sample data in excel file or your sample apps?

Re: Stopping values on data points overlapping

Anonymous — Mon, 08 Sep 2014 15:51:45 GMT

Sorry Manish, I am unable to provide sample data or app.

Re: Stopping values on data points overlapping

MK_QSL — Mon, 08 Sep 2014 15:57:37 GMT

I know due to data sensitivity, you can't provide, but obviously you can make 10 - 15 lines dummy data and can provide in excel file or in Apps itself using INLINE Load...without this it's sometimes difficult to answer question.

Re: Stopping values on data points overlapping

jvitantonio — Mon, 08 Sep 2014 16:07:48 GMT

Hi a workaround would be to add the data points within the bar.

Go to properties --> Presentation, and check the option "Plot value inside segment".

I hope this helps.

Re: Stopping values on data points overlapping

Mon, 08 Sep 2014 16:17:11 GMT

you can do something above using...

Go to properties --> Presentation, and check the option called Plot value inside segment.

Vinay

Re: Stopping values on data points overlapping

Anonymous — Tue, 09 Sep 2014 07:53:07 GMT

Thanks Vinay. Unfortunately, with my data, the line often runs through the middle of the bar and overlaps the data value inside the segment.

Re: Stopping values on data points overlapping

israrkhan — Tue, 09 Sep 2014 08:07:52 GMT

what about it..?

Re: Stopping values on data points overlapping

Anonymous — Tue, 09 Sep 2014 08:11:48 GMT

Thanks, but unfortunately, with my data, the line often runs through the middle of the bar and overlaps the data value inside the segment.

Re: Stopping values on data points overlapping

Tue, 09 Sep 2014 08:21:38 GMT

Try like this properties-->Axes-->Check split Axis--> change the primary value as you need

Re: Stopping values on data points overlapping

Tue, 09 Sep 2014 08:23:56 GMT

another way Expression--> For any one expression check text on axis

Re: Stopping values on data points overlapping

Siva_Sankar — Tue, 09 Sep 2014 08:38:55 GMT

Greg,

An idea is proposed to Qliktech under 'Ideas'. Will see if we get any updates in next releases.

http://community.qlik.com/ideas/2764

Re: Stopping values on data points overlapping

Anonymous — Tue, 09 Sep 2014 08:40:19 GMT

Thanks