Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Is it possible to create an arithmatic scale ?

Dear All

I have created a scatter chart with x axis as expiry date & y axis as contract spend.

There are few contract which has some 100 Million USD + spend while many in the 0.1 to 10 Million USD.

Because of some few high spend contracts, the graph become skewed.

Is it possible to show arithmatic scale, dividing the y axis into three part

0 to 10 Mio USD

10 to 100 Mio USD

100 + USD

Thanks in advance!

Best Regards

Rahul Kale

1 Solution

Accepted Solutions
Not applicable

Re: Is it possible to create an arithmatic scale ?

Did you try the  log10 function

So your expression should be  log10( sum(Y))

JJ

2 Replies
Not applicable

Re: Is it possible to create an arithmatic scale ?

Did you try the  log10 function

So your expression should be  log10( sum(Y))

JJ

Not applicable

Re: Is it possible to create an arithmatic scale ?

Thanks JJ

Community Browser