topic Re: Bar Chart fill in QlikView

Bar Chart fill

Anonymous — Tue, 04 Nov 2014 21:43:41 GMT

Hello,

I was wondering if it is possible to fill a bar chart up to a certain point. Or to have a way to stack a certain value in front. Here is a sample incorrect that I would like to fulfill:

I would like to fill a different color if possible up to the plan total of 54.5% which would be 97.8% of the overall June value. If that is not possible, is it possible to put a bar graph in front of June, with the Plan value. If this is possible please share the syntax how to complete.

Re: Bar Chart fill

Tue, 04 Nov 2014 21:52:52 GMT

Hola Justin.

Si lo que quieres es limitar tu gráfica a un solo valor puedes hacerlo en Propiedades>ejes y delimitar tu eje a ese valor o crear una linea de referencia con el valor.

Espero haberte ayudado Saludos!

Re: Bar Chart fill

Anonymous — Wed, 05 Nov 2014 14:47:44 GMT

Perez,

Thank you for the suggestion. That is an option. But can we partially fill bars on a bar chart? or is there a way to put a plan % in front of an actual amount?

Re: Bar Chart fill

Wed, 05 Nov 2014 21:18:20 GMT

A ver si te entiendo, lo que quieres hacer es graficar tu porcentaje real y solo mostrar tu porcentaje planeado, estoy en lo correcto!?

Re: Bar Chart fill

MarcoWedel — Wed, 05 Nov 2014 22:36:44 GMT

Hi,

you could use stacked bar charts with the difference between actual and plan values stacked on top of the plan value

-> plan + (actual-plan) = actual

hope this helps

regards

Marco

Re: Bar Chart fill

Anonymous — Thu, 06 Nov 2014 15:58:47 GMT

Marco and Perez,

Thank you for the suggestions. Since the difference in this example is so small, the stacked bar does not look good. What I would be looking for would be a way to fill the bar color up to a certain point. I know how to change the color of the bar graph in total, but is there a way to color a portion based off of a function?

Say I wanted to change the color of the above bar graph to green I would put in green(). If I wanted to use an if statement to change it only if the value is over 1, then I would use an if statement. Is there a way to use an if statement or other formula to color a bar for only 60%, and have the rest of the bar the original color? Or is there a better way to stack given user requirements?