selection of a particular date and we get all previous date selected

[#1]

i have a table having a date column which i have taken in list box.

now i want that if i select a particular date,the charts should be refreshed with all the previous dates.

example :

if i select 09/13/2013 the data should be of >09/13/2013

or if i select 01/02/2013 the data should be of >01/02/2013

[marcus_sommer]

You could do this with a OnChange-Trigger on this field. Sometimes is for such actions a separate date-field useful.

- Marcus

[#3]

Hi,

Try this

vSelectedDate=GetFieldSelection(FieldName)

Use this is in the chart expression

=SUM({<[Datefield]={">=$(=$(#vMaxOrderDate)"},Year=,Month=,Quarter=>}Fieldname to be sum)

[Sokkorn]

Hi Amrit,

Suppose that we have object:

1. Listbox -> For date selection

2. Line Chart

     a. Dimension: Date Field

     b. Expression: Sum(Sale)

To get your requirement done, we need to use calculated dimension; something like

Calculated Dimension: =Aggr(Only( {$<DateField = {">=$(=Date(Min(DateField),'dd-MM-yy'))"}>} DateField),DateField)

Expression: Sum(Sale)

It would be great if you have sample app here.

Regards,

Sokkorn

[er_mohit]

See the attached video

Hope it helps you

[#6]

Hi Mohit,

i cant see any video attached.can you plz send me the link