Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Charts

I am getting the Y axis dimension as 150000,100000,50000 but i want to convert them into 150,100,50 ??????????????

1 Solution

Accepted Solutions
vupen
Partner - Creator
Partner - Creator

You can control the display of the units on the Y-axis(Expression value) by specifying a symbol for either Thousands, Millions or Billions. This can be done on the Number tab of the Chart properties dialog.

Based on the symbol specified, the Y-axis value is divided by one of those numbers (thousand/million/billion).

However, the actual expression value remains the same.

Attached is a sample file.

View solution in original post

9 Replies
Not applicable
Author

From where i can get the format  pattern for displaying the dimensions like  0.50,100,150  in the line chart ??  

Not applicable
Author

I guess you dont have control in giving the scale.

vupen
Partner - Creator
Partner - Creator

You can control the display of the units on the Y-axis(Expression value) by specifying a symbol for either Thousands, Millions or Billions. This can be done on the Number tab of the Chart properties dialog.

Based on the symbol specified, the Y-axis value is divided by one of those numbers (thousand/million/billion).

However, the actual expression value remains the same.

Attached is a sample file.

Not applicable
Author

when i am creating a chart I am getting the values on Y axis as 20000,150000,100000, but i want to further break it and also want the negative values ?????? plz help

vupen
Partner - Creator
Partner - Creator

Work around is to multiply/divide the expression value with a constant like <exp>*-1/5000.

If you can be more specific as to what 20000 should become, or what value be translated into a negative value, then I can suggest something.

Not applicable
Author

on Y axis  I am getting the value like this (0 , 50000,100000,150000,200000) and i want it them to be like (  -20000,0,20000,40000,60000,80000,100000,120000,140000,160000,180000,200000,220000)

vupen
Partner - Creator
Partner - Creator

I believe you want a 'Static Axis', irrespective of the Y value. You can achieve that by setting Static Min, Static Step and/or Static Max on the Axes tab of the chart properties.

Attached is the sample.

Not applicable
Author

yea thats correct

Not applicable
Author

what you said i tried but it is not working properly ,  i am trying in combo chart ???????????????