Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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