topic Re: Data point at bottom side in QlikView

Data point at bottom side

prma7799 — Wed, 09 Dec 2015 09:53:14 GMT

Hi swuehl‌ / All,

I am trying to show data points values bottom as like below in screen shot but not didn't get it.

PFA.

Re: Data point at bottom side

Kushal_Chawda — Wed, 09 Dec 2015 09:55:19 GMT

Like this

How to show data points at bottom

Re: Data point at bottom side

prma7799 — Wed, 09 Dec 2015 09:58:37 GMT

Yes

i already did this and i dont want that blank space.

Thanks

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 10:02:34 GMT

Which blank space you are talking about?

Re: Data point at bottom side

prma7799 — Wed, 09 Dec 2015 10:06:15 GMT

Hi Balraj,

Please refer this also

Months should come with previous months data

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 10:16:11 GMT

like this?

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 10:17:29 GMT

update your Bottom expression with this :

=(Sum({<Year=, Quarter=, FinancialYear, Year=, MonthYear= {">=$(=Date(Addmonths(Max(MonthYear),-23),'MMM-YYYY'))<=$(=Date(Max(MonthYear),'MMM-YYYY'))"}>}

Values)/10000000)

Re: Data point at bottom side

prma7799 — Wed, 09 Dec 2015 10:38:28 GMT

Hi Balraj,

I want data point at bottom side...

You just removed from above dual and round function but we want that because of data point will go down.

Re: Data point at bottom side

nagarjuna_kotha — Wed, 09 Dec 2015 10:41:18 GMT

PFA

-Nagarjuna

Re: Data point at bottom side

Kushal_Chawda — Wed, 09 Dec 2015 10:51:31 GMT

See the attached

Re: Data point at bottom side

prma7799 — Wed, 09 Dec 2015 11:02:50 GMT

Hi Kush,

Thanks for quick response but all bars display only 1 not actual values.

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 11:06:35 GMT

thats becoz through Dual() function you are assigning then only 1

Remove Dual function with 1, you will get actual values

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 11:08:43 GMT

like this?

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 11:09:41 GMT

see this for more clarity:

Dual & Exists – Useful Functions

Re: Data point at bottom side

prma7799 — Wed, 09 Dec 2015 11:16:03 GMT

I am getting actual value but on top of the bar I want values at bottom

Re: Data point at bottom side

tresB — Wed, 09 Dec 2015 11:20:16 GMT

PFA

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 11:20:45 GMT

see this?

Re: Data point at bottom side

Anonymous — Wed, 09 Dec 2015 11:22:57 GMT

Hi,
I have on trick for your requirement please follow the below steps:
1)Create exact similar copy of your existing chart .
2) Inside the copied chart check values on data point option and unchecked values inside the segment option.
3) Go to the axis tab and set min =0 and max =99999999
4)Make everything invisible from copied chart like caption, label, axis, border of chart , label everything.
Only make visible data point values.
5)go to the color and make the background of copied chart as fully transparent.
6)go to the layout and change the layer level to the bottom .
7)now inside the original chart make the color of each bar slightly transparent.
8)and place both chart on each other to get the result.

Thanks,
Sandip Satbhai

Re: Data point at bottom side

prma7799 — Wed, 09 Dec 2015 11:31:54 GMT

Thanks tresesco‌.

What you did can you please explain lit bit.

Thanks

Re: Data point at bottom side

tresB — Wed, 09 Dec 2015 11:36:48 GMT

Apart from expression, Number tab->Number format 'Expression Default' for Bottom; color/size adjustment for the Bottom exp symbols.