Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
Partner

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
Partner

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

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
Partner

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
Partner

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 ???????????????