# New to QlikView

Discussion board where members can get started with QlikView.

Contributor

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

4 Replies
MVP

## Re: Networking days non associate data

Try this

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

*

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

Contributor

## Re: Networking days non associate data

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,

MVP

## Re: Networking days non associate data

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

Contributor

Hi Sunny,