Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stjernvd
Partner - Creator
Partner - Creator

Network Days set analysis not working

Hi,

I have a chart with the following settings:

Dimension:

Place (legend)

MonthYear (x-axis)

Expression: Count(Place)/$(vBusDays)

$(vBusDays) is NetWorkDays(Min({1<MonthYear=>}Date),Max({1<MonthYear=>}Date))

This works fine in my pivot table if I remove Place as my dimension and just keep MonthYear, then it shows the correct expression, however when I include both place and monthyear the data is incorrect.

For example for January 2015, it should divide Count(Place) by 22, instead when I have Place and MonthYear as my dimensions, it divides Count(Place) by 21, why is this happening? Even though I have used set analysis for networkdays!!

3 Replies
Not applicable

usually this happen when exists problem relationation, check if exists values null or duplicate, probably in the Place some value is null..

Not applicable

I think it is right when it divide by 21...

In Jan 2015 has 21 work days...

sunny_talwar

Would you be able to share a sample to look at?