Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ArtemZadorozhnyi
Contributor II
Contributor II

Wide range of values in bar chart

Hi! 

In Qlik Sense I have such bar chart:

ArtemZadorozhnyi_0-1708346015726.png

I'd like the low values to be more visible. I thought about manual setting the range for Y-axis, but the value range is too wide. I've also tried logarithmic scale, but then the numbers don’t really make any sense:

ArtemZadorozhnyi_0-1708359296677.png

Is there a way to use log10 (for bars' scale) but still have the Value labels showing the original values? 

 

Labels (1)
1 Solution

Accepted Solutions
theoat
Partner - Creator III
Partner - Creator III

Hey, you can use the function dual.

Dual(original value, log10(value)).

If you use the function dual, set the format of your measure on « measure expression ».

Kind regard,

Théo Atragie.

View solution in original post

1 Reply
theoat
Partner - Creator III
Partner - Creator III

Hey, you can use the function dual.

Dual(original value, log10(value)).

If you use the function dual, set the format of your measure on « measure expression ».

Kind regard,

Théo Atragie.