Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My date contains up to 8/17/2015 when i checked with listbox.
But i need to show show the report like this,and from 8/18/2015 it would be null values.
You will need to create a Master Calendar in the script to have them available in the list box. Look here for the Master Calendar: Creating A Master Calendar
HTH
Best,
Sunny
I need report like as per second image.
That is possible only if you have those dates in the application. We can show you how it can be done if you can share some sample data in Excel format (Instead of the image)
Best,
Sunny
Dear Naresh,
Please add listed below statement in your load script,
if(myDateField > '8/18/2015', null(), myDateField) as myDateField //you can write variable name instead of 8/18/2015
Kind regards,
Ishfaque Ahmed
This?
Script:
Table:
LOAD Date,
Value
FROM
Community_178604.xlsx
(ooxml, embedded labels, table is Sheet1);
Temp:
Load Min(Date) as minDate,
Max(MonthEnd(Date)) as maxDate
Resident Table;
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
DROP Table Temp;
TempCalendar:
LOAD Date($(varMinDate) + IterNo() - 1) as Date
AutoGenerate 1
While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
Straight Table:
Dimension: Date
Expression: Sum(Value)
On the Presentation tab uncheck 'Suppress Zero Values'
Thank you sunny its working fine.
Awesome
I am glad it worked.
Best,
Sunny