topic Re: Rangesum different results QlikSense - QlikView in App Development

Rangesum different results QlikSense - QlikView

raffaeleamadi — Wed, 04 Nov 2020 14:22:07 GMT

Hi guys,

I get different results using the same rangesum function in Qlikview versus QlikSense.
In Qlikview, even in the absence of data, the progressive value is reported in all rows, while in QlikSense this does not happen.
Obviously I am using the same data source (see attachments)
Do you have any ideas for achieving the same result in QlikSense as in QlikView?

my calculated item is

rangesum(above (sum(value),0,NoOfRows()))

Thanks

Raffaele

Re: Rangesum different results QlikSense - QlikView

QFabian — Wed, 04 Nov 2020 14:52:59 GMT

Hi, try this :

if(rowno()=0,sum(value),
rangesum(above (sum(value),0,NoOfRows())))

Re: Rangesum different results QlikSense - QlikView

raffaeleamadi — Wed, 04 Nov 2020 15:01:41 GMT

Hi Fabian, not Working...