Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulating Percentage

I have a Pivot Table which has Date post was sent out to the client on the left and Weeks until returned across the top. what I am trying to create is for it to tell me of the Post sent in the week on the left how much in % has returned in week 1,2,3,4 Ect.

then I need to do the same but accumulative so of the post sent on the date on the left a % of all received in week 1 then in the week 2 Column it needs to show all received in weeks 1&2 and so on.

This is an example of what the data looks like

Week sentweek return 1week return 2week return 3week return 4
10/5/15291430
17/5/153590
21/5/154700
28/5/153000

Accumulative should look like this

Week Sent

week return 1week return 2week return 3week return 4
10/5151%3%10%20%
17/5/152%4%21%
21/5/151%6%
28/5/152%

I have tried the basic Count([Week Returned]) / Count ([Week Sent])

and then tell sense to display as number and as % but what I get is either all data as 100% or everything as 0

Any help would be much appreciated

1 Solution

Accepted Solutions
Not applicable
Author

I have now solved this

This was done by using the following expression

RangeSum(Before(Count([Days to post return]),0,ColumnNo()))


Days to post return was built into the load script as a DateDiff between Week Sent and Week Return this is then used in the expression.

the load script is like this

[Days to post return] = DATEDIFF(Week,[Week Sent Date],[Week Return Date]) /1

Cheers


View solution in original post

1 Reply
Not applicable
Author

I have now solved this

This was done by using the following expression

RangeSum(Before(Count([Days to post return]),0,ColumnNo()))


Days to post return was built into the load script as a DateDiff between Week Sent and Week Return this is then used in the expression.

the load script is like this

[Days to post return] = DATEDIFF(Week,[Week Sent Date],[Week Return Date]) /1

Cheers