article Visual tricks with Charts in Qlik Learning Documents https://community.qlik.com/t5/Qlik-Learning-Documents/Visual-tricks-with-Charts/ta-p/1485643 <HTML><HEAD></HEAD><BODY><P>Hi, everyone!</P><P></P><P>Today I want to share with you with some tricks which you may use to improve your projects/dashboards from visual side.</P><P><SPAN style="font-size: 13.3333px;">The main idea of this post is using a function RangeSum() to achieve a different results which can be used to define a colors in your charts.</SPAN></P><P>In the attached file you will find a four charts with different results of the same thing:</P><P>The first one gives an answer for the question "Is the next bar is bigger than previous or not?"</P><P>The second shows a dynamic and mark plot values with symbols ▲/▼ (alt+30, alt+31).</P><P>The third shows a number of bars that bigger than average among all values.</P><P>And the last one tells a user how good or bad a business are going. It accumulate a difference between adjacent bars and at the end we can see a total difference. If it's uder the zero the plot area will be red, else - green.</P><P></P><P>Also, you can be interested with the 2nd chart because it's a combined of two similar charts, but with the different visualization.</P><P></P><P>Note: often use of function rangesum() may reduce a performance of your project! Don't get carried away <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P>Also you can find how to use a refference lines.</P><P></P><P>I will be pleased if this material will help you even a little!</P></BODY></HTML> Sun, 14 May 2017 14:17:41 GMT Sergey_Shuklin 2017-05-14T14:17:41Z Visual tricks with Charts https://community.qlik.com/t5/Qlik-Learning-Documents/Visual-tricks-with-Charts/ta-p/1485643 <HTML><HEAD></HEAD><BODY><P>Hi, everyone!</P><P></P><P>Today I want to share with you with some tricks which you may use to improve your projects/dashboards from visual side.</P><P><SPAN style="font-size: 13.3333px;">The main idea of this post is using a function RangeSum() to achieve a different results which can be used to define a colors in your charts.</SPAN></P><P>In the attached file you will find a four charts with different results of the same thing:</P><P>The first one gives an answer for the question "Is the next bar is bigger than previous or not?"</P><P>The second shows a dynamic and mark plot values with symbols ▲/▼ (alt+30, alt+31).</P><P>The third shows a number of bars that bigger than average among all values.</P><P>And the last one tells a user how good or bad a business are going. It accumulate a difference between adjacent bars and at the end we can see a total difference. If it's uder the zero the plot area will be red, else - green.</P><P></P><P>Also, you can be interested with the 2nd chart because it's a combined of two similar charts, but with the different visualization.</P><P></P><P>Note: often use of function rangesum() may reduce a performance of your project! Don't get carried away <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P>Also you can find how to use a refference lines.</P><P></P><P>I will be pleased if this material will help you even a little!</P></BODY></HTML> Sun, 14 May 2017 14:17:41 GMT https://community.qlik.com/t5/Qlik-Learning-Documents/Visual-tricks-with-Charts/ta-p/1485643 Sergey_Shuklin 2017-05-14T14:17:41Z