Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Painting values on data points

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:

Chart.JPG

1 Solution

Accepted Solutions
miguelbraga
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

11 Replies
miguelbraga
Partner - Specialist III
Partner - Specialist III

Hi Luiz,

Have you tried to check

Values on Data Points.png

Regards,

MB

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

Not applicable
Author

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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.

Kushal_Chawda

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