topic Re: Best way to visualize data with extreme value differences in QlikView https://community.qlik.com/t5/QlikView/Best-way-to-visualize-data-with-extreme-value-differences/m-p/963593#M526435 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P>456932 = 456.9 K = 0.5 M</P><P></P><P>But in all of this is a big risk of misinterpreting the data through the user - therefore be very careful.</P><P></P><P>By a certain type of data like profit &amp; loss categories could be a waterfall chart suitable: <A href="https://community.qlik.com/docs/DOC-3139">How to create Water Fall Charts</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 22 Dec 2015 01:16:51 GMT marcus_sommer 2015-12-22T01:16:51Z Best way to visualize data with extreme value differences https://community.qlik.com/t5/QlikView/Best-way-to-visualize-data-with-extreme-value-differences/m-p/963592#M526434 <HTML><HEAD></HEAD><BODY><P style="margin: 0 0 1em; font-size: 15px; color: #222426; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; background-color: #fcfcfc;">I am working on some routines for a client application .The data is inconsistent&nbsp; of smaller values and large values. For example:</P><P style="margin: 0 0 1em; font-size: 15px; color: #222426; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; background-color: #fcfcfc;">456932</P><P style="margin: 0 0 1em; font-size: 15px; color: #222426; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; background-color: #fcfcfc;">12</P><P style="margin: 0 0 1em; font-size: 15px; color: #222426; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; background-color: #fcfcfc;">17</P><P style="margin: 0 0 1em; font-size: 15px; color: #222426; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; background-color: #fcfcfc;">4569383</P><P style="margin: 0 0 1em; font-size: 15px; color: #222426; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; background-color: #fcfcfc;">What will be the best way to visualize such data (Like in Bar chart it shows very uneven difference).Please suggest.</P></BODY></HTML> Mon, 21 Dec 2015 12:58:39 GMT https://community.qlik.com/t5/QlikView/Best-way-to-visualize-data-with-extreme-value-differences/m-p/963592#M526434 2015-12-21T12:58:39Z Re: Best way to visualize data with extreme value differences https://community.qlik.com/t5/QlikView/Best-way-to-visualize-data-with-extreme-value-differences/m-p/963593#M526435 <HTML><HEAD></HEAD><BODY><P>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:</P><P></P><P>456932 = 456.9 K = 0.5 M</P><P></P><P>But in all of this is a big risk of misinterpreting the data through the user - therefore be very careful.</P><P></P><P>By a certain type of data like profit &amp; loss categories could be a waterfall chart suitable: <A href="https://community.qlik.com/docs/DOC-3139">How to create Water Fall Charts</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 22 Dec 2015 01:16:51 GMT https://community.qlik.com/t5/QlikView/Best-way-to-visualize-data-with-extreme-value-differences/m-p/963593#M526435 marcus_sommer 2015-12-22T01:16:51Z Re: Best way to visualize data with extreme value differences https://community.qlik.com/t5/QlikView/Best-way-to-visualize-data-with-extreme-value-differences/m-p/963594#M526436 <HTML><HEAD></HEAD><BODY><P>Here is a collection of ideas on how you can visualize it</P><P><A href="http://ux.stackexchange.com/questions/36408/how-to-visualize-data-with-extreme-value-differences" title="http://ux.stackexchange.com/questions/36408/how-to-visualize-data-with-extreme-value-differences">info visualisation - How to visualize data with extreme value differences? - User Experience Stack Exchange</A></P></BODY></HTML> Wed, 13 Jan 2016 01:08:31 GMT https://community.qlik.com/t5/QlikView/Best-way-to-visualize-data-with-extreme-value-differences/m-p/963594#M526436 swuehl 2016-01-13T01:08:31Z