Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

try this expression then,

sum(total<Country>Sales)

View solution in original post

12 Replies
Highlighted
Partner
Partner

Hi,

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

S.

Highlighted
Partner
Partner

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

Highlighted
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

Highlighted
Partner
Partner

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

Highlighted
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

Highlighted
Creator
Creator

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

Untitled.jpg

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

try this expression then,

sum(total<Country>Sales)

View solution in original post

Highlighted
Creator III
Creator III

hi Hopkinsc,

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

cheers,

Ganesh