topic Re: Log Scale Scientific Notation in QlikView

Log Scale Scientific Notation

Mon, 02 Nov 2015 17:44:20 GMT

Does anyone know how to get y-axis values to display in scientific notation while the axis is log-scale? Right now it shows up as 1m, 1um, 1pm etc. My data ranges from 10^-3 to 10^-12, and I would like the axis values to show up at 1x10^-6, 1x10^-7. Tried changing the settings under the number tab in the chart properties but didn't get it to change the y-axis values.

Re: Log Scale Scientific Notation

MarcoWedel — Tue, 03 Nov 2015 00:10:34 GMT

Hi,

maybe one solution could be:

hope this helps

regards

Marco

Re: Log Scale Scientific Notation

Tue, 03 Nov 2015 00:51:43 GMT

That seems to be pretty close, but I would like the 1x10^ would be next to each y-axis grid point value.

Re: Log Scale Scientific Notation

rwunderlich — Tue, 03 Nov 2015 06:48:40 GMT

You can modify Marco's expression to include the 1x10^. Note that you have to use an "Oh" instead of zero in the pattern so it's not mistaken as a digit selector. Downside is that your popups will show the rounded value, so you may want to turn the popups off.

=num(log10(Value),'1x1O^0')

More about including special text in y-axis here:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Log Scale Scientific Notation

Wed, 04 Nov 2015 00:49:20 GMT

This is what I get while doing that. Any idea what to do about the changing format for anything double digit? I also tried using '1xE' and the double digit problem happens there too.

Re: Log Scale Scientific Notation

swuehl — Wed, 04 Nov 2015 18:06:17 GMT

I couldn't reproduce the issue with above sample file and expressions.

Could you upload a sample QVW?

Maybe try

=num(Log10(Value),'1E#')

Re: Log Scale Scientific Notation

Wed, 04 Nov 2015 18:21:23 GMT

=num(Log10(Value),'1E##') worked for me and fixed the last two values.

=num(Log10(Value),'1x10^##') also works.

Only problem is that the chart won't be bound by the min and max I sent, and the axis label isn't coming up, but I can live with that, and it's probably an unrelated issue.

Re: Log Scale Scientific Notation

swuehl — Wed, 04 Nov 2015 18:37:17 GMT

Interesting, now I see your issue, just playing around with switching options on / off.

Nevermind...

What do you use as min and max values / expressions. I think you need to use the log10 values, like

Max: -3

Min: -12

Step: 1