Rangesum in pivot table exlcuding selection

[prashanthd]

Hi All,

I need help in how to write the set expression for cumulative sum in pivot table. Week selection should not affect the calculation. i have tried  to write the expression but when selecting week it filters  but still shows dimension values

Expression for Cumulative sum : RangeSum(before(Count({<[Reporting Date.autoCalendar.YearWeek]>}distinct [PR No]),0,ColumnNo(total)))

Attached screenshots.

[SRA]

Hi,

Can you try :

RangeSum(before(Count({<[Reporting Date.autoCalendar.YearWeek]=>}distinct [PR No]),0,ColumnNo(total)))

Regards

[prashanthd]

sorry it still the same. does not work . Attached the test QVF file

[SRA]

Hi,

The formula is working when removed from the Pick(Match(ValueList...

First table : with the Pick(Match(ValueList / Second table without :

You are not alone to have this issue... 

https://community.qlik.com/t5/App-Development/SET-Analysis-Not-working-within-Pick-Match-ValueList/t...

https://community.qlik.com/t5/App-Development/Set-Analysis-when-using-pick-match-function/td-p/17212...

[prashanthd]

Hmmm thanks for sharing. Any workaround to get around this?

[prashanthd]

Actually my requirement is when week is selected it should show only the selected week but the cumulation should be intact .

i dont want to show all the weeks