topic Re: Networking days non associate data in QlikView

Networking days non associate data

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

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

Thanks in Advance...!!!

sunny_talwar — Mon, 11 Jun 2018 19:06:04 GMT

Try this

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

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

paulwalker — Wed, 13 Jun 2018 17:53:11 GMT

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 — Wed, 13 Jun 2018 19:43:53 GMT

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

paulwalker — Wed, 13 Jun 2018 20:03:54 GMT

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