Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I reflect maxdate in the table box? When I just select Date, it reflects the calendar date.
Thanks
In a table box or text box?
May be this:
=Date(Max(DateField)) in as text box object
Its the table box, I reflect 2017 though our data should be just until the current day
Try restricting your fact table to today's date in that case:
Where Num(Date) <= Num(Today());
Thanks Sunny I appreciate your help, but I am really very new with this so please bear with me. How can I do that?
Sure thing
Can you share your script here?
This is what I have
Binary RawData.qvw;
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET MaxDate='Today()';
Dimensions:
LOAD * INLINE [_row
Tool
Date
Category
Application
];
Metrics:
LOAD * INLINE [_valueNo, _value
1, Effort (Hours)
2, Assigned
3, Completed
4, Work in Progress
];
Status:
LOAD * INLINE [_stat
Assigned
Completed
Work in Progress
];