topic Combo chart values on data points colors? in QlikView

Combo chart values on data points colors?

ganeshreddy — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am facing an issue on adjusting data points in combo chat,

the required output of the chart should be like

but our chart output is appearing like below shown.

How to move values on data points on top of each combo bar as shown in first pic, for example in third bar(70%) is in incorrect position. For the values on data points i am using third expression and keeping that bar expression as invisible.

Thanks,

Ganesh

Re: Combo chart values on data points colors?

Anil_Babu_Samineni — Fri, 20 Jan 2017 10:07:00 GMT

May be try with these, Chart seems simple Bar chart but your title showing Combo Chart. Please confirm that which chart is that

1) To set single bar - Please check Stacked Radio Button

2) To plot and showing good data points, May be check vertical option from Presentation Tab of that object

Re: Combo chart values on data points colors?

sunny_talwar — Fri, 20 Jan 2017 10:18:32 GMT

Is 'Bar' unchecked also? on the expression's tab?

Re: Combo chart values on data points colors?

ganeshreddy — Fri, 20 Jan 2017 11:07:22 GMT

Hi Sunny,

No Bar option is checked, if i un-check the Bar option the color code for values is not appearing.

I have given below shown options for values expression,

Re: Combo chart values on data points colors?

ganeshreddy — Fri, 20 Jan 2017 11:09:37 GMT

Hi Anil,

It is combo chart only, the same chart is reused for several other KPIs(conditional enabling) so we can not change it to Bar staked/grouped bar chart.

Thanks

Re: Combo chart values on data points colors?

sunny_talwar — Fri, 20 Jan 2017 11:54:53 GMT

No Bar option is checked, if i un-check the Bar option the color code for values is not appearing.

Color code for values is not appearing? Not sure I understand

Re: Combo chart values on data points colors?

Anil_Babu_Samineni — Fri, 20 Jan 2017 12:39:55 GMT

How about this?

Because, I used this when i was with same issue. That time i have 20-25 values with Good Visualization. I just convey and discuss with the client regarding this. So that, They've agree with me finally and i proved my self too.

Re: Combo chart values on data points colors?

ganeshreddy — Fri, 20 Jan 2017 13:43:58 GMT

Hi Sunny,

Currently bar potion is checked.

if i Un-check the bar option in expression tab colored values for values on data points are not appearing. FYI please find below.

For more info the % values are having separate expression i.e to show values on data points.

Thanks,

Re: Combo chart values on data points colors?

sunny_talwar — Fri, 20 Jan 2017 13:47:08 GMT

Would you be able to share a sample where you are trying this out? Might be easier for me to play around with a little to see if I can get what you want

Re: Combo chart values on data points colors?

Ponkaviyarasu — Fri, 20 Jan 2017 14:08:15 GMT

Hi Ganesh,

How did you calculate the % expression value, Can you share the Snapshot of the calculation.

Re: Combo chart values on data points colors?

ganeshreddy — Fri, 20 Jan 2017 14:36:35 GMT

Thanks Sunny for asking this,

PFA sample work file. Actually my aim is to adjust all colored value points to the top of each bar.

you can see, as of now there is no uniformity on placing those values.

Re: Combo chart values on data points colors?

ganeshreddy — Fri, 20 Jan 2017 14:47:32 GMT

In actual app by using below shown options we are calculating % expression values,

Re: Combo chart values on data points colors?

ganeshreddy — Fri, 20 Jan 2017 14:48:41 GMT

Expression is [CY Value]/[PYValue]

Thanks

Re: Combo chart values on data points colors?

ganeshreddy — Mon, 23 Jan 2017 09:57:44 GMT

Hi Sunny,

Any luck on adjusting all colored value points to the top of each bar.

Re: Combo chart values on data points colors?

Anil_Babu_Samineni — Mon, 23 Jan 2017 13:40:39 GMT

From this, What are you expecting to show the Data points?

Re: Combo chart values on data points colors?

sunny_talwar — Mon, 23 Jan 2017 13:44:46 GMT

No man.... not able to get it done...