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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
m_woolf
Master II
Master II

Axis static step for Scatter Chart

When I set a static step value for my scatter chart, the axis takes on the formatting of the expression.

How can I keep the expression formatted as is, but show the axis formatted as integers?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Yeah, the formatting can be annoying.

Are you looking for

2017-05-19 18_46_57-QlikView x64 - [E__Users_Stefan_Downloads_Sample (23).qvw_].png

?

The only thing I've change is changing number format of X expression to expression default.

View solution in original post

10 Replies
Anil_Babu_Samineni

May be this for Static Step

=vXStep * 0.00001

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
m_woolf
Master II
Master II
Author

Thanks for the reply. When I change the variable, the axis step doesn't change.

Anil_Babu_Samineni

What do you mean the change of Variable over here, Can you explain little more the issue

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
m_woolf
Master II
Master II
Author

If the variable that I'm using for the static step is confusing, forget about it.

If you edit the chart and put in any static step value for the x-axis (try 5), the axis formatting will change to display 6 decimal places (like the X expression).

I want to be able to specify a static step without changing the formatting on the axis.

Anil_Babu_Samineni

Like this?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
m_woolf
Master II
Master II
Author

No. You've changed the formatting for the X expression. Now when I hover over the chart, I don't see the actual values for the X expression.

I want the X expression to show 6 decimals and the axis to show integers. This is the case when the axis step is automatic, but when you change to static step the axis takes on the formatting of the X expression.

I'm thinking that this is a bug. This can't be what anyone would want.

Anil_Babu_Samineni

May be others can help you

swuehl

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

May be try the attached....

Capture.PNG

And it is a bug, but comes in handy a lot of the times

Currency and Other Symbols on the Y-Axis | Qlikview Cookbook

swuehl
MVP
MVP

Yeah, the formatting can be annoying.

Are you looking for

2017-05-19 18_46_57-QlikView x64 - [E__Users_Stefan_Downloads_Sample (23).qvw_].png

?

The only thing I've change is changing number format of X expression to expression default.