topic How to show data points at bottom in QlikView

How to show data points at bottom

prma7799 — Thu, 05 Nov 2015 06:24:18 GMT

Hi All,

How to show data points at bottom of bars like below.

PFA..

Re: How to show data points at bottom

Anonymous — Thu, 05 Nov 2015 06:28:31 GMT

You want to show within bar chart only or on X axis you want to plot?

Re: How to show data points at bottom

prma7799 — Thu, 05 Nov 2015 06:39:34 GMT

I want data points within bars at bottom...

Re: How to show data points at bottom

gautik92 — Thu, 05 Nov 2015 06:46:37 GMT

i hope you cant show values lik that instead you can try text on axis on expression tab

Re: How to show data points at bottom

Anonymous — Thu, 05 Nov 2015 06:49:12 GMT

Not possible,

But alternate is what: you can place a text box with those values at the bottom of bar chart and removing value on data points option.

Its like "jugad"

Re: How to show data points at bottom

prma7799 — Thu, 05 Nov 2015 06:51:11 GMT

I can but requirement is that only.

Is there any option to do that?

Thanks

Re: How to show data points at bottom

gautik92 — Thu, 05 Nov 2015 06:53:21 GMT

you can try balrajahlawat‌ suggestion but its quite difficult

Re: How to show data points at bottom

nagarjuna_kotha — Thu, 05 Nov 2015 07:00:59 GMT

Its Not possible in Bar chart.

Regards,

Nagarjuna

Re: How to show data points at bottom

jagan — Thu, 05 Nov 2015 07:09:40 GMT

Hi,

It is not possible to implement this in Qlikview, you don't have control over the values display in the chart like top, bottom, or center. By default it is center.

Regards,

Jagan.

Re: How to show data points at bottom

settu_periasamy — Thu, 05 Nov 2015 07:34:03 GMT

Hi,

Not sure, But may be you can create the one more expression. (which is already you used to show the Bar)

it should be something like

=sum(Sales)&Repeat(chr(160),25)

In the second expression,

Uncheck the Bar, and Check the Values on DataPoint in Display Options

You need to do some adjustment of repeated count value based on your sum(sales) data

This is not a proper solution. But, something we have..

Edit:

Sample Attached

Re: How to show data points at bottom

PrashantSangle — Thu, 05 Nov 2015 07:41:38 GMT

Hi,

Yes, It is possible.

Follow below steps :

1: Instead of Bar chart use Combo chart.

2: Add your expression. (Uncheck Values on Data Points)

3: Again add expression with some modification like

Dual(YourExpression,sum(0.1)) (Check Values on Data Points)

Regards

Re: How to show data points at bottom

prma7799 — Thu, 05 Nov 2015 07:47:29 GMT

Hi Max / Settu

Your both solution is working fine but data point show with growth.

@Settu : Not as you images

I am using combo chart with one bar and one line...

PFA...

Thanks

Re: How to show data points at bottom

settu_periasamy — Thu, 05 Nov 2015 07:56:14 GMT

Hi,

can you provide the sample?