Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a & Increase Chart in QlikView

Hi

I was just curious to know how to create a percentage change chart in QlikView.

Currently on my QlikView document, I have a gauge chart which shows a % change in sales from one month to another. So comparing to see at what percentage of sales has increased or decreased from one to another. This is fine as this shows just one % change when you select months.

I would rather like to see a trend of the % change and I was curious to know if this was possible to do in QlikView as this would show a clear graphical analytical representation of how and why and increase in sales has occured.

Thanks

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this expression: above(sum(sales))/sum(sales)-1


talk is cheap, supply exceeds demand