topic Re: Calculation of rotation days in QlikView

Calculation of rotation days

vikas_nandanwar — Tue, 16 Jan 2018 06:10:28 GMT

Hi,

I have a set of data consisting of columns as Month, Week, Office, Sales and Inv.

Few points to be considered-

My period starts from 1st Jan 2017.

I need to calculate Rotation days as

(No of Days from 1st Jan) / [(Total Sales till Date)/(Average Inv till date)]

When i distribute it month wise, i don't get the average

Please help

I am attaching my app and data with this.

Thanks,

Vikas

sunny_talwar — Tue, 16 Jan 2018 13:06:11 GMT

Check here:

vikas_nandanwar — Thu, 18 Jan 2018 11:29:49 GMT

Avg(Days)*

RangeAvg(Above(TOTAL(Avg(Aggr(Sum(Inv),Months,Week))),0,If(RowNo()<6,RowNo(),6)))/

RangeSum(Above(TOTAL(Sum(Sales)),0,If(RowNo()<12,RowNo(),12)))