Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
yipchunyu
Creator
Creator

Month-on-Month change in mini chart (positive negative)

We just upgraded our server and happy to learn the new feature of mini chart in straight table.

I am Ok to use the sparkline and bar chart.  However, I can't work out a correct positive/negative mini chart.

What I want to do is showing a positive / negative indicators for improved market share in quarter (compared to the previous one)

Expression for Market share are sth like:

=
Sum({$<PERSPECTIVE={"$(=vPerspective)"} >} [#CQ_SALES])
/
Sum({$<PERSPECTIVE={"$(=vPerspective)"} >} TOTAL [#CQ_SALES])

How can I make positive growth (market share) as 1 and negative growth as -1 and show it correctly in the mini-chart?

Labels (1)
0 Replies