Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My calendar script is loading fine but the table not reflecting any changes. Below the code i am using
Calendar:
load Distinct
"sDate",
Year("sShipment Date") As PostingYear,
Month("sShipment Date") As PostingMonth,
Week("sShipment Date") As PostingWeekOnly,
WeekDay("sShipment Date") As PostingWeekDay,
Day("sShipment Date") As PostingDay,
'Q' & Ceil(Month("sShipment Date")/3) As PostingQuarter
resident myTable;
Temp:
Load
min("sDate") as minDate,
max("sDate") as maxDate
Resident Calendar;
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
I create calendar object but when I pick the date I don't see change in my straight table.
I want when change start and end date to get result in my table between start and end date. Does anyone have an idea?
Perhaps this video tutorial helps: Selecting Arbitrary Date Ranges
Where do you want to get the result of between the dates? if you are using variable for the calendar object, you need put the variable inside of the Expression (I guess you are using Straight or Pivot chart). like
=sum({<sDate={">=$(varMinDate)<=$(varMaxDate)"}>}Sales)
Can you post the expression of your straight table?
Perhaps this video tutorial helps: Selecting Arbitrary Date Ranges
Thanks Gysbert, that's it...