topic Network Days set for each month in QlikView

Network Days set for each month

stjernvd — Thu, 10 Dec 2015 21:31:50 GMT

Hi,

I have my months (January-September) and my Count(Place) expression.

vDays= NetworkDays(Min(date),Max(date))

In my chart I have MonthYear (e.g. Jan-2015, etc...) as my Dimension and as my Expression: Count(Place)/($(vDays)).

The issue I have is that when no month is selected, vDays = 194, and this messes up my charts since Count(Place) should be divided by a different number each month, since each month has different network days, and instead it divides Count(Place) by 194.

How do I create a variable vDays that recognizes that even when no month is selected, it knows that for each Month-Year (e.g. Jan-2015, Feb-2015) that vDays is a different number and not 194 days?

Re: Network Days set for each month

swuehl — Thu, 10 Dec 2015 22:49:00 GMT

You probably defined your variable vBusDays with a leading equal sign. Just remove the leading equal sign, so that the dollar sign expansion will expand the variable to

Count(Destination) / (NetworkDays(Min(Tradedate),Max(Tradedate)))

I assume that Tradedate field is linked to your TradeMonthYear, so Min and Max are derived from dimension value on each dimension line.

Re: Network Days set for each month

stjernvd — Fri, 11 Dec 2015 09:33:10 GMT

Thank you so much!