Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Best way to visualize data with extreme value differences

I am working on some routines for a client application .The data is inconsistent  of smaller values and large values. For example:

456932

12

17

4569383

What will be the best way to visualize such data (Like in Bar chart it shows very uneven difference).Please suggest.

2 Replies
marcus_sommer

You could enable within the tab axis a logarithm scale or you tried to show your values with different units at the same chart like:

456932 = 456.9 K = 0.5 M

But in all of this is a big risk of misinterpreting the data through the user - therefore be very careful.

By a certain type of data like profit & loss categories could be a waterfall chart suitable: How to create Water Fall Charts.

- Marcus

swuehl
MVP
MVP