topic Re: Network Days only changes for month and year in QlikView

Network Days only changes for month and year

stjernvd — Wed, 06 Jan 2016 13:03:39 GMT

Hi,

I need an expression where network days only changes if you select a month and year, and ignores all other filters.

Here is my equation:

=NetWorkDays(Min(Month={$(vMonthMinus10)},Year={$(vYearMinus10)}>}Date),Max(Month={$(vMonthMinus10)},Year={$(vYearMinus10)}>}Date))

However, when I select other filters, network days changes, and instead it should remain the same for each month and year, regardless of other filters.

So for example, January 2015 has 22 business days, I want it to always be 22 business day for January 2015 (trade month = Jan and trade year = 2015) regardless of other filters.

How do I set this in my expression?

FYI: vYearMinus10 = 2015 and vMonthMinus10 = January

Re: Network Days only changes for month and year

sunny_talwar — Wed, 06 Jan 2016 13:05:57 GMT

May be this:

=NetWorkDays(Min({1<TradeMonth={$(vMonthMinus10)},TradeYear={$(vYearMinus10)}>}TradeDate),Max({1<TradeMonth={$(vMonthMinus10)},TradeYear={$(vYearMinus10)}>}TradeDate))

Re: Network Days only changes for month and year

Chanty4u — Wed, 06 Jan 2016 13:08:18 GMT

NetWorkDays(Min(TradeMonth={$(vMonthMinus10)},TradeYear={">=$(vYearMinus10)}>}TradeDate),Max(TradeMonth={$(vMonthMinus10)},TradeYear={$(vYearMinus10)"}>}TradeDate))

Re: Network Days only changes for month and year

stjernvd — Wed, 06 Jan 2016 13:16:44 GMT

it works thank you!:)

Re: Network Days only changes for month and year

sunny_talwar — Wed, 06 Jan 2016 13:20:27 GMT

Awesome, I am glad it worked