topic mtd calculation by using week range in QlikView

mtd calculation by using week range

Anonymous — Tue, 14 Feb 2012 11:08:39 GMT

hi folks,

how can i calculate month to date in pivot table.

by using 1st week total,2nd week total,3rd week total

means add the data of week range to get sum of 30 days

plz find the attached excel(sample target)

v_iyyappan — Tue, 14 Feb 2012 11:33:19 GMT

hi,

Use the Dimension Month in Chart.

=SUM({<

Year=,

Month=,

DateFieldNum=

{'>=$(=(num(WeekStart(DateField))))<=$(=(num(WeekEnd(DateField))))'}>}Sales)

Where

DateFieldNum= Num(DateField)

Regards,

Iyyappan