topic Re: -7 network days calculation syntax in QlikView

-7 network days calculation syntax

Mon, 03 Jun 2013 07:58:04 GMT

Hi i am trying to set an expression to calculate the last seven working days.

I have one key figure - weeklyusage

the syntax i have is as follows, however is incorrect

=sum(networkdays(today()-7), weeklyusage)))

Your help is greatly appreciated.

Best,

Bradley

alexandros17 — Mon, 03 Jun 2013 08:10:17 GMT

if the field related to time is myDate then

=sum({$ <myDate={'=$(networkdays(today()-7)'}>}), weeklyusage)))

hope it helps

thomas_skariah — Mon, 03 Jun 2013 08:13:19 GMT

Hi,

You can use below code.

sum({<date={">=$(=AddMonths(Max(date-6),0))<=$(=Max(date))"}>} Value).

Regards,

Tom

Mon, 03 Jun 2013 08:22:23 GMT

Hi Alexandros!

thank you for your tip

unfortunately it is not working to calculate value is still 0.

however the syntax appears to be correct.

Gysbert_Wassenaar — Mon, 03 Jun 2013 08:45:52 GMT

Try sum({$<MyDate={'>=$(firstworkday(today(),7))'}>} weeklyusage)