accumalation of data on calender basis

[#1]

i have a calender and daywise data in pivot.i need to show data mtd wise in pivot.

like if a person click on some purticular date say 10 apr ,then he should be able to see total business till 10.

please help .

Thanks

vantrika

[ramoncova06]

you can use the min and max of selected fields

Sum({1<Date = {">=$(=(date(monthstart(max(Date)))))<=$(=(max(Date)))"}>}Sales)

here is more info into date ranges

QlikView App: Dates, Date Ranges and Set Analysis

[#3]

hi,

try this

Sum({<Year= , Date = {">=$(=date(Monthstart(max(Date))))<=$(=max(Date))"}>}Sales)

hope this will help you