topic Re: Is it possible to create an arithmatic scale ? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-an-arithmatic-scale/m-p/425244#M1158996 <HTML><HEAD></HEAD><BODY><P>Did you try the&nbsp; log10 function</P><P></P><P>So your expression should be&nbsp; log10( sum(Y))</P><P></P><P></P><P>JJ</P></BODY></HTML> Tue, 11 Dec 2012 20:53:26 GMT 2012-12-11T20:53:26Z Is it possible to create an arithmatic scale ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-an-arithmatic-scale/m-p/425243#M1158995 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have created a scatter chart with x axis as expiry date &amp; y axis as contract spend.</P><P></P><P>There are few contract which has some 100 Million USD + spend while many in the 0.1 to 10 Million USD.</P><P></P><P>Because of some few high spend contracts, the graph become skewed.</P><P></P><P>Is it possible to show arithmatic scale, dividing the y axis into three part</P><P></P><P>0 to 10 Mio USD</P><P>10 to 100 Mio USD</P><P>100 + USD</P><P></P><P>Thanks in advance!</P><P></P><P>Best Regards</P><P>Rahul Kale</P></BODY></HTML> Tue, 11 Dec 2012 12:24:32 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-an-arithmatic-scale/m-p/425243#M1158995 2012-12-11T12:24:32Z Re: Is it possible to create an arithmatic scale ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-an-arithmatic-scale/m-p/425244#M1158996 <HTML><HEAD></HEAD><BODY><P>Did you try the&nbsp; log10 function</P><P></P><P>So your expression should be&nbsp; log10( sum(Y))</P><P></P><P></P><P>JJ</P></BODY></HTML> Tue, 11 Dec 2012 20:53:26 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-an-arithmatic-scale/m-p/425244#M1158996 2012-12-11T20:53:26Z Re: Is it possible to create an arithmatic scale ? https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-an-arithmatic-scale/m-p/425245#M1158997 <HTML><HEAD></HEAD><BODY><P>Thanks JJ</P></BODY></HTML> Fri, 14 Dec 2012 05:09:48 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-create-an-arithmatic-scale/m-p/425245#M1158997 2012-12-14T05:09:48Z