Discussion board where members can get started with QlikView.
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!
Go to Solution.
Did you try the log10 function
So your expression should be log10( sum(Y))