topic Re: Painting values on data points in QlikView

Painting values on data points

Tue, 10 Nov 2015 16:07:07 GMT

hello, everyone!

I just want to know, if is possible to paint the value area in the chart as we could do in excel:

I've been trying to do that all day long.

Example:

Re: Painting values on data points

miguelbraga — Tue, 10 Nov 2015 16:39:40 GMT

Hi Luiz,

Have you tried to check

Regards,

Re: Painting values on data points

miguelbraga — Tue, 10 Nov 2015 16:40:35 GMT

Please share your qvw or your Excel file so that we make a similar solution

Re: Painting values on data points

miguelbraga — Tue, 10 Nov 2015 16:45:01 GMT

Find this useful vídeo:

https://www.youtube.com/watch?v=-WIjMxAjRA4

Re: Painting values on data points

Tue, 10 Nov 2015 16:57:01 GMT

Miguel, first of all, thanks for reply me!

I got to give values on data points, however, I can't paint it. (Put that gray board around the values)

I want to put that, because I have two lines and sometimes, they intersect, overlapping the datas.

Do you have any idea?

Kind Regards, Luiz

Re: Painting values on data points

miguelbraga — Tue, 10 Nov 2015 17:03:09 GMT

The last expression used as line chirt in the combochart must be something like this:

="Blue"+"Red"

In there you must check the "Value on Data Point".

Hope it helps you

Re: Painting values on data points

miguelbraga — Tue, 10 Nov 2015 17:09:15 GMT

You can increase the distance between your bars, just go to the Presentation nad in the Bar Settings, increase the Bar Distance

Re: Painting values on data points

miguelbraga — Tue, 10 Nov 2015 17:12:25 GMT

Or you can make them vertically so that the values don't overlap . Can't see any better way to solve your problema...

Re: Painting values on data points

Tue, 10 Nov 2015 17:17:57 GMT

Hello Michael, I think I was not very clear (Again, thanks for the help).

I would like to paint the data, have a combined bar graph and lines. And I would like to paint the data labels (which are already inserted in the lines) because the lines cross and the data end up overlapping each other. I can insert the labels but not pintalos, giving them the gray background.

Thanks for the help, carefully. Luiz

Olá Miguel, penso que não fui muito claro (Mais uma vez, obrigado pela ajuda).

Gostaria de pintar os dados, tenho um gráfico combinado de barras e linhas. E gostaria de pintar os rótulos de dados (Que já estão inseridos nas linhas), pois as linhas se cruzam e os dados acabam sobrepondo uns aos outros. Consigo inserir os rótulos, mas não pintalos, dar à eles o fundo cinza.

Obrigado pela ajuda, atenciosamente. Luiz

Note: Edited by moderator to include translation as a courtesy.

Re: Painting values on data points

Kushal_Chawda — Tue, 10 Nov 2015 18:24:26 GMT

I think you can't do it the same in QlikView. If the values are intersecting you can adjust the data point values by plotting the values inside the bars

Re: Painting values on data points

rwunderlich — Tue, 10 Nov 2015 23:53:34 GMT

Take a look at this tutorial:

Qlikview Cookbook: Tutorial - Annotating Chart Data Points http://qlikviewcookbook.com/recipes/download-info/tutorial-annotating-chart-data-points/

I don't think you can paint the gray background, but as Braga suggested you can adjust the position to avoid overlap.

-Rob

Re: Painting values on data points

Wed, 11 Nov 2015 00:34:59 GMT

Yes, you're right, it is not possible to paint the gray background, but I did what Braga said.

And your qvw was really helpful! Thank you!