Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

paulwalker
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

Capture.JPG

Thanks in Advance...!!!

4 Replies

Re: Networking days non associate data

Try this

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

*

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


Capture.PNG

paulwalker
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,

Re: Networking days non associate data

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

Capture.PNG

paulwalker
Contributor

Re: Networking days non associate data

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

Community Browser