Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner
Partner

values on data points query

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

1 Solution

Accepted Solutions
amarbogam
Creator
Creator

try this expression then,

sum(total<Country>Sales)

View solution in original post

12 Replies
simospa
Partner
Partner

Hi,

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

S.

hopkinsc
Partner
Partner
Author

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

ganeshreddy
Creator III
Creator III

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

hopkinsc
Partner
Partner
Author

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

ganeshreddy
Creator III
Creator III

Hi ,

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

amarbogam
Creator
Creator

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

Untitled.jpg

hopkinsc
Partner
Partner
Author

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

amarbogam
Creator
Creator

try this expression then,

sum(total<Country>Sales)

View solution in original post

ganeshreddy
Creator III
Creator III

hi Hopkinsc,

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

cheers,

Ganesh