topic Re: values on data points query in QlikView

values on data points query

hopkinsc — Fri, 10 Apr 2015 13:30:40 GMT

hi all, is there a way i can get the full value showing on my data points but have the scale only showing the reduced numbers.

i.e.

my values are in the millions, so the full number on data point (77,000,000) but the scales just showing 10 20 30 40 50 60 70 80 etc

I have attached an example

thanks

Re: values on data points query

simospa — Fri, 10 Apr 2015 13:37:34 GMT

Hi,

try to remove in Number --> Thusand Symbols and Million Symbol the label £ Thousands and £ Milion.

Re: values on data points query

hopkinsc — Fri, 10 Apr 2015 13:42:22 GMT

Hi, thanks, if i do that then the scale will show the full value also. i want the scale to remain as it is

Re: values on data points query

ganeshreddy — Fri, 10 Apr 2015 14:00:26 GMT

Hi,

PFA ....please find the solution there. this is how you can represent in this situation.

if you find its the answer, please mark it as correct answer

Re: values on data points query

hopkinsc — Fri, 10 Apr 2015 14:04:54 GMT

Hi, thanks, its useful but not the answer i'm afraid.

i need the full value displayed on the end of the bars. i can get this if i remove the symbols from the number tab but that impacts the scale too.

my client has just upgraded from v9. in v9 this was possible but it doesnt seem possible in v11.2

Re: values on data points query

ganeshreddy — Fri, 10 Apr 2015 14:13:07 GMT

Hi ,

This post is extension to the above post. you can mark values plot inside option form presentation tab. PFA

Re: values on data points query

Anonymous — Fri, 10 Apr 2015 14:24:14 GMT

1. Add a second expression as shown in image below,

Re: values on data points query

hopkinsc — Fri, 10 Apr 2015 14:28:09 GMT

hi, thanks. this is something i have already tried. it doesnt give the total, it give the value of the last segment in the bar.

i need it to show the total value of sum(Sales).

i.e.

UK = 52,000,000

US = 77,000,000

Thanks

Re: values on data points query

Anonymous — Fri, 10 Apr 2015 14:35:46 GMT

try this expression then,

sum(total<Country>Sales)

Re: values on data points query

ganeshreddy — Fri, 10 Apr 2015 14:38:03 GMT

hi Hopkinsc,

PFA. this file may may help to achieve your task. In exp tab see total expression.

cheers,

Ganesh

Re: values on data points query

ganeshreddy — Fri, 10 Apr 2015 15:06:25 GMT

Hi Hopkinsc,

Please post the QVW which consist Amar Bogam's answer. which may help me in future.

cheers,

Ganesh

Re: values on data points query

hopkinsc — Fri, 10 Apr 2015 15:18:09 GMT

example attached

Re: values on data points query

ganeshreddy — Fri, 10 Apr 2015 18:21:35 GMT

Thank you.