topic Re: accumulating sales using rowno in QlikView

accumulating sales using rowno

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am using following formula for accumulate sales: RangeSum(Above($(vSalesACT), 0, RowNo())) / SUM( total {$<DataCategory = {'ACT'}, Cat1_ID = {'1'}>} $(=%VALUE))

Unfortunately the sort funktion is not working. Is there any trick to avoid rowno?

Rgds

SandMan

Re: accumulating sales using rowno

varshavig12 — Tue, 12 Jul 2016 09:34:02 GMT

Peek() can help you.

Can you provide a sample data and the expected output ?

Re: accumulating sales using rowno

varshavig12 — Tue, 12 Jul 2016 09:37:14 GMT

What you actually want to sum up,

sum of $(vSalesACT) from its current position till ?Is it from the first row till the current position ?

Are you using a straight table ?

Re: accumulating sales using rowno

Tue, 12 Jul 2016 09:39:07 GMT

I want to sum up Sales for selected stores --> 1st postion until last. yes straight table

Re: accumulating sales using rowno

sunny_talwar — Tue, 12 Jul 2016 10:20:14 GMT

You are doing this in which chart object? You might be able to use Aggr() function without script manipulation if you are using QV12

The sortable Aggr function is finally here!

Re: accumulating sales using rowno

Tue, 12 Jul 2016 10:43:08 GMT

we are using QV 11

Re: accumulating sales using rowno

varshavig12 — Tue, 12 Jul 2016 11:39:18 GMT

you can check the link posted by Sunny.

In case still you are stuck, then let us know by providing sample data.

Re: accumulating sales using rowno

Tue, 12 Jul 2016 14:07:02 GMT

installed QV12. how should the formula look like?