Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

agigliotti
Honored Contributor II

pivot table with rangesum

Hello,

Does is possible to have an expression total (for column) using the below expression:

rangesum( before( sum(sales), 0, RowNo() ) )

as accumulate measure over months ?

for example how to have total for jan, feb etc... ? now I'm getting 0.

many thanks in advance.

best regards

Andrea

Tags (1)
1 Solution

Accepted Solutions

Re: pivot table with rangesum

Try it with NoOfColumns() if you want to accumulate columns maybe with something:

rangesum( before( sum(sales), 0, NoOfColumns(TOTAL)))

- Marcus

1 Reply

Re: pivot table with rangesum

Try it with NoOfColumns() if you want to accumulate columns maybe with something:

rangesum( before( sum(sales), 0, NoOfColumns(TOTAL)))

- Marcus

Community Browser