topic Re: labels truncated in chart in QlikView

labels truncated in chart

olivierrobin — Thu, 08 Nov 2018 09:41:11 GMT

hello

You will find a sample in the attached qvw.

The problem is :

I have a label which is the concatenation of two texts and I want i to be displayed on the points of data. The problem is that this label may be truncated (see value for key b)/

as you can see, the chart is sized to the maximum.

I also tried :

create another column with value multiplied by a factor (eg: 1.5 , 2 , ....)

fix a max scale value in axis / scale

it seems to work but there is always a case where label is truncated.

I have the same problem with vertical bars where label is split on 2 lines.

Any ideas ?

Re: labels truncated in chart

Frank_Hartmann — Thu, 08 Nov 2018 10:05:57 GMT

try like this:

Re: labels truncated in chart

olivierrobin — Thu, 08 Nov 2018 10:09:23 GMT

hello

as I said, I already tried it and it seems to work but there is always a value which make the label to be truncated

Re: labels truncated in chart

jonathandienst — Thu, 08 Nov 2018 10:30:28 GMT

No easy workaround other than reserving enough space. You could also use

Max(Aggr(Sum(val1),key)) * 1.3

Adjust the factor as required

Re: labels truncated in chart

Frank_Hartmann — Thu, 08 Nov 2018 11:34:11 GMT

and when you also take into regard the length of the visible text ?

static max formula for sum(val1) :

max(aggr(sum(val1),key)) * len(sum(val1)&sum(val1))