topic Re: Log Scale is not displaying real values in QlikView

Log Scale is not displaying real values

Anonymous — Tue, 05 Sep 2017 15:37:50 GMT

Hi,

I have a table that with the following structure:

Year-Month

Items created

Items sold

Store

So, in some months we sold the stock and not as many as we created, for example:

Store Year-Month IC IS

1 2017-01 100 25

2 2017-01 20 7

3 2017-01 55 30

1 2017-02 50 30

2 2017-02 12 15

3 2017-02 40 16

1 2017-03 110 90

2 2017-03 28 7

3 2017-03 35 30

I have created a line chart to display the percentage of sales against creation. Like the following:

The information is displayed properly (the values are calculated IC/IS to get the percentage). The problem is with the log scale, it's not displaying correct or understandable values. If I removed the log scale I got the following:

The numbers cannot be read. Is there a way to manipulate the log scale to represent the data from 0 to 10% and then the rest. I will like to see the information as the first chart but with the scale similar to the second.

Is this possible?

Thanks,

Re: Log Scale is not displaying real values

el_aprendiz111 — Tue, 05 Sep 2017 17:22:22 GMT

Hi,

Re: Log Scale is not displaying real values

rubenmarin — Tue, 05 Sep 2017 17:33:52 GMT

Hi, also you can set the limits for the axis in the 'Scale' box. Set 0.1 in 'Static Max' to limit it to 10%

Re: Log Scale is not displaying real values

vvira1316 — Tue, 05 Sep 2017 17:53:44 GMT

Will it be possible for you to provide sample data set?

Re: Log Scale is not displaying real values

Anonymous — Tue, 05 Sep 2017 20:38:04 GMT

This worked, however the numbers above 100% are not being displayed (as this one case and don't happened anymore I will leave it this way).

Thank you!

Re: Log Scale is not displaying real values

rubenmarin — Wed, 06 Sep 2017 07:54:32 GMT

Hi Roberto, have you tried Fer answer to split the axis?

You can try splitting the axis and setting limits for each splitted axis, the bad thing about this is that usually the max limit label of the bottom chart overlaps with the min limit label of the upper chart.

Re: Log Scale is not displaying real values

Anonymous — Wed, 06 Sep 2017 12:16:32 GMT

Yes, I have tried that, but didn't work, that change didn't modify the chart.

Re: Log Scale is not displaying real values

rubenmarin — Wed, 06 Sep 2017 12:58:34 GMT

Have you splitted the expressions between Top and bottom in the 'Position' box?

Once you have set the split axis you need to select wich expressions will go on the upper chart and wich go to the lower. If all expressions have 'Top' or all expressions have 'Bottom' it doesn't does anything

Re: Log Scale is not displaying real values

Anonymous — Wed, 06 Sep 2017 13:25:54 GMT

Don't know what you mean, if I clicked on Split Axis and select the Primary, but nothing happened. am I missing something?

Re: Log Scale is not displaying real values

rubenmarin — Wed, 06 Sep 2017 13:28:27 GMT

Ok, it won't work with only one expression. I though you had more than one, sorry for confusing you.

Re: Log Scale is not displaying real values

vvira1316 — Wed, 06 Sep 2017 14:16:27 GMT

You may want to check following discussion.

Logarithmic bar chart shows null dimensional value with larger count than other values is showing up at bottom/out of so…

If you are still having problem please include good size sample data

Re: Log Scale is not displaying real values

vvira1316 — Wed, 06 Sep 2017 14:18:04 GMT

This one also

Data Point Value is not completely visible in a Bar Chart with a Log Scale