Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

silambarasan130
Contributor II

RangeSum Not Working with Multiple Dimention..!!

Hi All,

Rangesum function is not working when i'm adding multiple dimension. I'm attaching the example qvf file.

Please give me the solution.

1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: RangeSum Not Working with Multiple Dimention..!!

Hi,

Expression for  multiple demension will be like below (look attached file)

RangeSum(Above(TOTAL Sum(Value), 0, RowNo(TOTAL)))


Regards,

Andrey

3 Replies
ahaahaaha
Honored Contributor

Re: RangeSum Not Working with Multiple Dimention..!!

Hi,

Expression for  multiple demension will be like below (look attached file)

RangeSum(Above(TOTAL Sum(Value), 0, RowNo(TOTAL)))


Regards,

Andrey

silambarasan130
Contributor II

Re: RangeSum Not Working with Multiple Dimention..!!

Hi Andrey,

Thank You.

ahaahaaha
Honored Contributor

Re: RangeSum Not Working with Multiple Dimention..!!

Was glad to help