Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to show week level data. And only to show data for WeekBeginDate for each week. Not summation of all dates.
I am using below expression:
sum({<DateSel = {Date(CstWeekBeginDate)}>}OrderQuantityOutstanding)
It is not working.
Can you please help me on this.
Thanks,
Sarif
Hi,
You can even create a Master Calendar in you Model having Date and WeekDay and in the Set analysis you can use Weekday = Mon
Sum({<Weekday= {'Mon'}>}OrderQuantityOutstanding)
Hi,
The best way is you define this first date in script and create a flag of the same.
So your mastercal should look like below.
Load Date,
if(Floor(Date) = Floor(weekstart(Date)),1,0) as WeekStartDateFlag
....
From xyz;
Now in set expression you just need to use this flag, like below.
Sum({<WeekStartDateFlag = {"1"}>}OrderQuantityOutstanding)
This expression will give you data for only 1st day of the week.
Regards,
Kaushik Solanki
is week start Monday? As our DB WeekStart Date is Sunday.
But if i do minus 1 . Then also it is not working.
Thanks,
Sarif
Can u pls share ur application
or change it weekstart sun in above environmental variables
I am not able to find weekstart in Environment variable.
Hi,
In your environment variable look for
FirstWeekDay, default value is 6 which is sunday, you can make it 0 for Monday.
Regards,
Kaushik Solanki
Set Daynames is there variable u can change the order of days
I set like this:
SET DayNames='Sun;Mon;Tue;Wed;Thu;Fri;Sat';
still not working.
Thanks,
Sarif
Hi,
You can even create a Master Calendar in you Model having Date and WeekDay and in the Set analysis you can use Weekday = Mon
Sum({<Weekday= {'Mon'}>}OrderQuantityOutstanding)