Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Networking days non associate data

Hi Community,

I'm facing issue with Networkdays non associate data.

My calculation like =(Sum(UnitPrice)/5) * Number of working days in a week


For example Lenin Jeansshorts, this product name have 15.37 unit price..

So my requirement, =(15.37/5) * (weeks)  

have a look below image, for week 1 data not coming, that should be = (15.37/5)* number of working days

Week 1=3.074 * 2   (2, number of working days in Week 1)

=6.14

Week 2=  3.074*5  (5 number of working days in Week 2)

=15.37

and same like Week 1..... to Week 52

Capture.JPG

Thanks in Advance...!!!

4 Replies
sunny_talwar

Try this

(SUM(TOTAL <ProductName>UnitCost)/5)

*

NetWorkDays(MIN(TOTAL <Week> {<ProductName>} OrderDate), MAX(TOTAL <Week> {<ProductName=>} OrderDate))


Capture.PNG

paulwalker
Creator II
Creator II
Author

Hi sunny,

Please could you see my expression, not working properly..

IF part not working, else part working fine....

IF(ProductName='Lenin Jeansshorts',

(SUM(AGGR(SUM(TOTAL <Month, ProductName> {<Week=>} Budget), Week, Month, ProductName))

/

NetWorkDays(MonthStart(MIN(OrderDate)), MonthEnd(Max(OrderDate)),  Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

Date#('04/02/2018', 'MM/DD/YYYY'), Date#('05/07/2018', 'MM/DD/YYYY'), Date#('05/28/2018', 'MM/DD/YYYY'), Date#('08/27/2018', 'MM/DD/YYYY'),

Date#('12/25/2018', 'MM/DD/YYYY'), Date#('12/26/2018', 'MM/DD/YYYY')))

*

NetWorkDays(MIN(OrderDate), MAX(OrderDate), Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

Date#('04/02/2018', 'MM/DD/YYYY'), Date#('05/07/2018', 'MM/DD/YYYY'), Date#('05/28/2018', 'MM/DD/YYYY'), Date#('08/27/2018', 'MM/DD/YYYY'),

Date#('12/25/2018', 'MM/DD/YYYY'), Date#('12/26/2018', 'MM/DD/YYYY')),

(SUM(TOTAL <ProductName>UnitCost)/5)

*

NetWorkDays(MIN(TOTAL <Week> {<ProductName>} OrderDate), MAX(TOTAL <Week> {<ProductName=>} OrderDate))

)

PFA,

sunny_talwar

Based on selection in Year and Month, there is no Budget value available

Capture.PNG

paulwalker
Creator II
Creator II
Author

Hi Sunny,

Thanks for reply..

Budget associating with 2018 and Jan...

My calculation here =SUm(Budget)/No of Working days in a month )* no of working days in a week

example Week 1 = (240/22)*4 =43.

Week2 = (240/22)*5 = 50  and so on...

Capture.JPG