topic custom values on data points in bar chart in QlikView

custom values on data points in bar chart

Thu, 18 Jun 2015 13:17:56 GMT

Hi all,

i have stacked bar chart for different kpi's.each kpi have weight.so i want show height accordingly with the weight of kpi.

ex:i have TQR,OOR,PPR kpi's.5,5,6 are corrsponding weights. so i am multipling expresion with weights.so far it is fine .but i want show values on data points for each stack with out weight .but default values on data points is value of expression.is there any way so that i can divide the weight and show only normal value in data points.

please suggest a solution.

thanks in advance..

Re: custom values on data points in bar chart

giakoum — Thu, 18 Jun 2015 13:20:14 GMT

You can create a new expression without weight, and check "Text on axis" and un check everything else.

It is not on data points but it is as close as you can get.

Of course you could also create a custom expression that will show on mouse over, but i am not sure if this is what you need

Re: custom values on data points in bar chart

Thu, 18 Jun 2015 13:22:40 GMT

this is giving value on axis ,but i need values on each stack of bar

Re: custom values on data points in bar chart

giakoum — Thu, 18 Jun 2015 13:23:48 GMT

not possible

And not a good idea I think. Will not your users be confused if the axis shows a different number that the value on data point?

Re: custom values on data points in bar chart

Thu, 18 Jun 2015 13:25:50 GMT

is there any tricky way i can get values

Re: custom values on data points in bar chart

giakoum — Thu, 18 Jun 2015 13:27:36 GMT

not that I know off

unless you want to create text in chart with the values or an overlapping chart

both are not good ideas as the chart changes according to selections

Re: custom values on data points in bar chart

Thu, 18 Jun 2015 13:27:56 GMT

that is requirement from user only.they need in that way and want y-axis to be hidden

Re: custom values on data points in bar chart

Thu, 18 Jun 2015 13:28:43 GMT

what about the option 'Values on Data Points'.

Re: custom values on data points in bar chart

giakoum — Thu, 18 Jun 2015 13:30:08 GMT

Charan is asking for values from a different expression

Re: custom values on data points in bar chart

kuba_michalik — Thu, 18 Jun 2015 14:18:32 GMT

You can try making your expression into a Dual() - make the text part (first) from value of KPI without weigths, and the numeric value (second) as your current expression. Example attached (chart on the right is for comparison, so you can see it works)

Re: custom values on data points in bar chart

Fri, 19 Jun 2015 09:48:33 GMT

thanks ,it worked.