Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.