Dates

[nareshthavidishetty]

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.

[sunny_talwar]

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

[nareshthavidishetty]

I need report like as per second image.

[sunny_talwar]

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

[engishfaque]

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

[sunny_talwar]

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'

[nareshthavidishetty]

Thank you sunny its working fine.

[sunny_talwar]

Awesome

I am glad it worked.

Best,

Sunny