Why is qlikview doing this ???

[#1]

Hi All,

I have two simple tables based on monthly volume and % against target, the only difference is one is per month and the other is cumulative:

Monthly Analysis
month	volume	target	volume/target
01/01/2011	25,210	30,000	84.03%
01/02/2011	30,300	35,000	86.57%
01/03/2011	29,200	32,000	91.25%
01/04/2011	36,500	33,000	110.61%
	121210	130000
Year To Date
month	volume	target	volume/target	Correct %
01/01/2011	25,210	30,000	84.03%	84.03%
01/02/2011	55,510	65,000	86.57%	85.40%
01/03/2011	84,710	97,000	91.25%	87.33%
01/04/2011	121,210	130,000	110.61%	93.24%

The volume & target expressions are set to full accumulation and the amounts are correct but % is incorrect, table still shows the month % not the cumulative %... aarrrgggh.

I've attached the example and I can't see why this happens do I need to use set analysis or something to get round this simple problem??

Many thanks,

Phil

[swuehl · Accepted solution]

You don't need set expression but I think you need inter record functions like above and rangesum:

try

=rangesum(above(sum(volume),0,RowNo()))/rangesum(above(sum(target),0,RowNo()))

as expression.

I think that the full accumulation is done pretty late in chart generation, it is not possible to access the accumulated values easily from other columns.

Stefan

[#3]

Thanks Stefan, I was trying to chart the variance so didn't think this answer would work, but it let me create the chart then disable the amounts and this % calculation still works to show the correct variance, I've attached the chart I created to show what I mean

Many thanks for your help.

Kind Regards,

Phil