https://community.qlik.com/t5/App-Development/Month-on-Month-change-in-mini-chart-positive-negative/m-p/1757244#M58433 <P>We just upgraded our server and happy to learn the new feature of mini chart in straight table.</P><P>I am Ok to use the sparkline and bar chart.&nbsp; However, I can't work out a correct positive/negative mini chart.</P><P>What I want to do is showing a positive / negative indicators for improved market share in quarter (compared to the previous one)</P><P>Expression for Market share are sth like:</P><P>=<BR />Sum({$&lt;PERSPECTIVE={"$(=vPerspective)"} &gt;} [#CQ_SALES])<BR />/<BR />Sum({$&lt;PERSPECTIVE={"$(=vPerspective)"} &gt;} TOTAL [#CQ_SALES])</P><P>How can I make positive growth (market share) as 1 and negative growth as -1 and show it correctly in the mini-chart?</P> Sat, 16 Nov 2024 17:54:10 GMT yipchunyu 2024-11-16T17:54:10Z https://community.qlik.com/t5/App-Development/Month-on-Month-change-in-mini-chart-positive-negative/m-p/1757244#M58433 <P>We just upgraded our server and happy to learn the new feature of mini chart in straight table.</P><P>I am Ok to use the sparkline and bar chart.&nbsp; However, I can't work out a correct positive/negative mini chart.</P><P>What I want to do is showing a positive / negative indicators for improved market share in quarter (compared to the previous one)</P><P>Expression for Market share are sth like:</P><P>=<BR />Sum({$&lt;PERSPECTIVE={"$(=vPerspective)"} &gt;} [#CQ_SALES])<BR />/<BR />Sum({$&lt;PERSPECTIVE={"$(=vPerspective)"} &gt;} TOTAL [#CQ_SALES])</P><P>How can I make positive growth (market share) as 1 and negative growth as -1 and show it correctly in the mini-chart?</P> Sat, 16 Nov 2024 17:54:10 GMT https://community.qlik.com/t5/App-Development/Month-on-Month-change-in-mini-chart-positive-negative/m-p/1757244#M58433 yipchunyu 2024-11-16T17:54:10Z