Date from and to selection

[#1]

Hi All,

I have a date column. My requirement is to create a selection where user will select from and to date.

Based on this selection data should displayed in between this from and to date.

I have tried by using calender object but not able to create from and to selection.

Could anybody help me on this??

Thanks,

Shailesh

[alexandros17]

Try using 2 input boxes for date From and Date To then compare your date to this 2 Others

let me know

[#3]

Hi Alessandro,

If i do so, i can get two dates as from and to.

But how i should make to select data which should displayed between only these two dates??

[Agis-Kalogiannis]

You can use two calendar objects with two variables

vMinDate and vMaxDate

and a set analysis expression

sum({$<Year={'>=$(vMinDate)<=$(vMaxDate)'}>}Sales)

Something like that will work

Agis

[alexandros17]

In your chart if you have a dimension that contains that date then :

If(Date >= DateFrom and Date <= DateTo, Date, Null())

and check the box "Suppress null values"

if you do not have this dimension, you have to control the date in the expression

[jpenuliar · Accepted solution]

Have a look at attached sample file by Colin Albert(K3FDS)

[#7]

Thank you all.

Now it working properly.

Regards,

Shailesh