Day Variance, MTD Variance and YTD Variance

Fri, 15 Jul 2011 01:21:06 GMT

Hi All:

I am trying to get this MTD variance and YTD variance to work in the Expression.

I have the field for Crate To and Crate From and the Day Variance working fine.

For the Day variance the Expression is as follows:-

sum (if (invtype='40',goodqty)) + sum (if (invtype='20',goodqty))

sum (if (invtype='42',goodqty)) - sum (if (invtype='34',goodqty))

Crate To

sum (if (invtype='40',goodqty)) + sum (if (invtype='20',goodqty))

Crate From

sum (if (invtype='42',goodqty)) + sum (if (invtype='34',goodqty))

Day Variance = Crate To – Crate From

I am trying to get the MTD variance and YTD variance to work.

The MTD variance should be the accumulated figures from Day variance and YTD variance should be the accumulated figures from MTD variance.

I try to use the ‘rangesum’ in the Expression but it does not seem to be working.

I am using Qlikview 7.5 so the setanalysis function does not work for me.

Could anyone share some light to this?

Thanks a lot

topic Day Variance, MTD Variance and YTD Variance in QlikView