Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have a look at attached sample file by Colin Albert(K3FDS)
Try using 2 input boxes for date From and Date To then compare your date to this 2 Others
let me know
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??
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
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
Have a look at attached sample file by Colin Albert(K3FDS)
Thank you all.
Now it working properly.
Regards,
Shailesh