topic Re: Line chart labels in QlikView

Line chart labels

Anonymous — Sun, 26 Jul 2015 15:33:03 GMT

Hi,

Is it possible to locate the labels of a line chart a bit more separate from the line?

Please see the file attached,

Thank you in advance,

Larisa

Re: Line chart labels

Nicole-Smith — Sun, 26 Jul 2015 16:22:43 GMT

You cannot control where the labels show up on the chart itself, but you can choose to have them show up on the axis instead:

Re: Line chart labels

Anonymous — Sun, 26 Jul 2015 17:09:09 GMT

Thank you!

Re: Line chart labels

veidlburkhard — Sun, 26 Jul 2015 19:03:59 GMT

Hi Larisa,

I think there is a workaround to get what you want by using the dual function.

Seems you have a line chart and marked 'Values on Datapoints' on the expression tab. Call this expression 'expression1'.

In order to get your desired result add a new expression like this: expression2 = Dual(Num(expression1, '# ##0.0'), expression1 + const.) , check 'Values on Datapoints' for this second expression and also 'Invisible'. Now uncheck 'Values on Datapoints' for your first expression. Very important thing is to go to the number tab and mark the 'Expression Default' checkbox for expression2 otherwise the dual function does not work.

The term const. is just the amount you want to shift the 'Values on Datapoints' up or down . If you want you can use a variable vShift instead of conts. and use a slider to adjust the shift easily.

Happy qliking

Burkhard

Re: Line chart labels

Anonymous — Mon, 27 Jul 2015 09:17:21 GMT

Hi,

I did as you suggested. But the shift (or const.) doesn't work.

Could you please have a look?

See the file attached.

Thank you in advance,

Larisa

Re: Line chart labels

veidlburkhard — Mon, 27 Jul 2015 09:48:58 GMT

Hi Larisa,

you did everything fine, but the shift value of 7 you are using is not recognizable with the naked eye. Please use 7000 and change your slider with values from 0 to 10000, step 1000.

With this you'll see the shift...

Regards

Burkhard

Re: Line chart labels

Anonymous — Mon, 27 Jul 2015 09:54:09 GMT

Thank you! It works.