topic Display Variance in QlikView

Display Variance

Mon, 30 Apr 2012 02:43:32 GMT

How to display Material Price Variance ,Labour usage variance ,Labour Price Variance ,Material Usage variance in a chart.Please suggest some ideas.I cannot think any other than bar graphs .

Display Variance

varunpbhandary — Mon, 30 Apr 2012 06:27:44 GMT

Hi vikramatantry,

It depends upon what you want to show to the user, Line chart is better for trend/trend Comparison like MoM, YoY. Bar chart is better used to compare two or more properties on same dimension, pie for comparison of contribution etc

So what you need to figure out is what is that you want the user to discover ?? ,and then decide upon the chart.

Cheers!

Varun

Display Variance

SunilChauhan — Mon, 30 Apr 2012 07:40:31 GMT

variance can be calculated using below formula

(Current Year amount- last year amount)/last year amount

hopt this helps