topic Re: Problem with values on chart data points in QlikView

Problem with values on chart data points

Thu, 07 Aug 2014 20:34:37 GMT

Hi, i have a line chart with values on data points. The problem is when two or more values on different expressions have a closed value because it looks stacked and this is imposible to read.

i hope somebody can to help me find anyway to resolve this problem.

Re: Problem with values on chart data points

ecolomer — Thu, 07 Aug 2014 20:41:52 GMT

Can you send an example to see them?

Re: Problem with values on chart data points

JonnyPoole — Thu, 07 Aug 2014 20:51:27 GMT

Its possible to come up with a conditional expression for the 'text color' under the expression that makes the color of the values transparent or not . This sample expression makes the text transparent (hides it) if there is more than one value for the x axis point: if( count( distinct <line dimension>) > 1 , ARGB(0,128,128,128), ARGB(255,128,128,128))

But thats a simple scenario and could easily filter out most of your values. You can get more sophisticated but it could get very complicated.

For what its worth, this kind of 'smart visualization' has been added in Qlik Sense. Here is a screenshot with no fancy properties or experessions to achieve this:

Re: Problem with values on chart data points

Thu, 07 Aug 2014 20:55:45 GMT

Re: Problem with values on chart data points

ecolomer — Thu, 07 Aug 2014 20:57:51 GMT

For a better view, I suggest to change to a horizontal view in style. Try it.

Saludos,

Enrique Colomer

Re: Problem with values on chart data points

Thu, 07 Aug 2014 20:58:07 GMT

Thank for tour response Jonathan, but i have to show it, i would like to find anyway to move value label for view both expression values.

Re: Problem with values on chart data points

Thu, 07 Aug 2014 21:03:40 GMT

Thanks, but modify my model means that project could be dismissed. i have to find the way to move these values without make visual changes

Re: Problem with values on chart data points

ecolomer — Thu, 07 Aug 2014 21:13:00 GMT

Another solution is put the value in line axis,

Re: Problem with values on chart data points

Thu, 07 Aug 2014 21:20:32 GMT

my values are stacked in this moment, i only want to make that two expression can be readed without problems. i can't make that you tell me because the requirement is show it at line end.

i haven't be able to find how to solve it. May this be solve?

Re: Problem with values on chart data points

ecolomer — Thu, 07 Aug 2014 21:24:50 GMT

Another possibility are put the value in a text with the expression

Re: Problem with values on chart data points

sudeepkm — Fri, 08 Aug 2014 05:36:00 GMT

you may think of changing the scale but at one point, for very close values that may also not satisfy your requirement.

Re: Problem with values on chart data points

Thu, 14 Aug 2014 15:06:13 GMT

I'll try it, many thanks.