Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How to round off Axis values in the chart?

Hello, 

I have a line and bar graph as shown below; 

1.PNG.

I changed the Sales value to 3 decimals (as highlighted in the chart) but my Axis also changed to 3 decimals. 

How to avoid this? (I want to see whole numbers in the axis and rounded to 3 decimals in the chart)

 

thanks

Bhavesh

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

What about copying the expression into a new expression. untick 'Show values on data points' on the original expression and tick it on the new expression, and also untick line on the new expression (so the new expression only has values on data points ticked and the old one only has line checked). 

Then remove the 3 decimals from the new expression (i guess you did that on the number tab?)

 

does that work?

 

 

View solution in original post

8 Replies
Highlighted
Partner
Partner

What about copying the expression into a new expression. untick 'Show values on data points' on the original expression and tick it on the new expression, and also untick line on the new expression (so the new expression only has values on data points ticked and the old one only has line checked). 

Then remove the 3 decimals from the new expression (i guess you did that on the number tab?)

 

does that work?

 

 

View solution in original post

Highlighted
Creator III
Creator III

That works fine. But is there any other way we can do using only one expression? 

Highlighted
Partner
Partner

Where are you applying the 3 decimals places? on the expression itself (using num()) or on the number tab?

Highlighted
Creator III
Creator III

I'm applying on the Number tab

Highlighted
Partner
Partner

When i make an expression 3 decimals on the number tab it doesn't change the axis, only the data points. So i am unsure why yours does unless its something to do with the data format. 

are you able to share a sample ? maybe reduce and scramble any sensitive data ?

Highlighted
Creator III
Creator III

Ah, I think when we enable the Static Step on the expression, the axis is also changing to 3 decimals. Try enabling the Static Step function for the expression and see if your axis is changing too. 

Highlighted
Partner
Partner

OK yes it is the static step that is changing the axis. I guess that is what you want though? unfortunately i don't think there is a way to use a different format on the data points in the same expression. 

I think the only option is to use a separate expression. is there any reason why you don't want to do it that way? if its ease of maintenance, you could create the expression as a variable and use the variable in each expression instead

 

Highlighted
Creator III
Creator III

Okay great, I will use the second expression for now. thank you for your response Smiley Happy