-
Notifications
You must be signed in to change notification settings - Fork 100
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Set YTD & MTD #68
Comments
Or maybe add CurrentFullYear & CurrentFullMonth :) |
Sorry to bother you, all of it sudden it started to work as it should. First the OrderReg_Qvc.Calendar_DateIsFuture stop showing me the "1" on 2017-10-10. And after a few reloads the set analysis included current date. Strange thing, I was thinking that there is someting wrong with my time but this morning it still works.. Maybe there is some varible that needs to be cleared?. I tried to find the issue in Qvc.qvs but the only thing I was able to find was that it depends on the "_f_DateIsFuture" flag. Im not sure if this is something wrong but I also found: For info we also need to include these lines in our script after latest release, if not paths doesen´t update. set vG.BasePath=; Regards David |
Yes, the SET should only have one underscore. I'll correct that, but it's just cleanup and shouldn't cause the problem you described. The current date is established in the load script. Could it be that the script ran before midnight and then you were analyzing on the following day? |
I found out that the vSetMTD shows different values depending och calandar. This is the script generating my calendars: |
Is Order.Date a derived field? |
No its not. |
The thing is that QVC 11.1 work just fine and I can set max calendar date to today() to achieve MTD and YTD som not show later values than Today. As you see the TerminationNotice.Date also showing different results depending on QVC version. |
Hi, Im not sure if this is a feature or a issue, but set operator YTD and MTD doesn´t show values in current date at the moment. For example we have a Sales dashboard and our sales-people really like to see there ordervalues in near real time.
At the moment max($(OrderRegvSetYTD) OrderRegDate) shows "2017-10-09"
The text was updated successfully, but these errors were encountered: