topic Re: RangeSum and Above with two dimensions in QlikView

RangeSum and Above with two dimensions

Mon, 17 Oct 2011 20:28:30 GMT

I've created an app showing last 3 months with the expression

rangesum (above(count( {$< corr_act_ok = {"Y"} >} corr_act_ok),0,3))

rangesum (above(count( {$< corr_act_ok = -{"N/A"} >} corr_act_ok),0,3))

The figures are correct when using one dimension. But, if I add one more dimension the figures are wrong.

Attached file showing this issue.

Someone who can help?

Re: RangeSum and Above with two dimensions

qliksus — Tue, 18 Oct 2011 07:17:53 GMT

Use the expression like this

rangesum (above(total count( {$< corr_act_ok = {"Y"} >} corr_act_ok),0,3))

rangesum (above(total count( {$< corr_act_ok = -{"N/A"} >} corr_act_ok),0,3))

Re: RangeSum and Above with two dimensions

Tue, 18 Oct 2011 09:41:19 GMT

It shows the correct figures for the first field ([Product Center]) in the cyclic group but if you choose another field in the group, like "FPP Causative unit", the figures aren't correct.

Re: RangeSum and Above with two dimensions

Tue, 21 May 2013 06:56:41 GMT

Hi Magnus,

Did you ever get this working? I'm having a similar issue.

Thanks,

Re: RangeSum and Above with two dimensions

jonathandienst — Tue, 21 May 2013 08:40:26 GMT

Are corr_act_ok and FPP Causative unit fields in a cyclic group? I think you can use the cyclic group name for the dimension in the Aggr() statement. That will work correctly when you change the field selection in the cyclic.

Hope that helps

Jonathan