Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
vikas_nandanwar
Creator II
Creator II

Calculation of rotation days

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

1 Solution

Accepted Solutions
vikas_nandanwar
Creator II
Creator II
Author

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)))

View solution in original post

2 Replies
sunny_talwar

vikas_nandanwar
Creator II
Creator II
Author

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)))