Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i want to select date which inferior to getcurrentselection Date.
so i do set analysis which don't work.
<date={"<$(=GetCurrentSelections(Date))"}>
Try this instead
{<date = {"$(='<' & Date(Max(date), 'DateFieldFormatHere'))"}>}
i'm a error message
i inform you that field date different to field Date
i want that i select one value in field date, i can see in field Date the values which inferior to value selected in field date.
example
date 2/10/2010,3//10/2010,4/10/2010 ;
Date 2/10/2010,3//10/2010,4/10/2010
when i selected 4/10/2010 in date; in Date, the possible value are 2/10/2010,3//10/2010
thank you
There are two approaches which you can try...
{<DateField1 = {"$(='<' & Date(Max(DateField2), 'DateFieldFormatHere'))"}>}
or
{<DateField1 = p(DateField2)>}
1st option would show all the rows where DateField1 is less than the Max(DateField2) selected.
2nd option would show all those rows where DateField1 equals one of the DateField2 selected.
Note: DateField2 is the Date field where you will be making selection and is not linked to DateField1
i prefer 1rst approch
{<Date1= {"$(='<' & Date(Max(Date2), 'dd/mm/yyyy'))"}>}
but i'm error when i want to look.look at screnshot.thank you
Hahahaha
I think you just used the set expression part here. Where is the aggregation here? You need to use it like this:
Sum({<Date1= {"$(='<' & Date(Max(Date2), 'dd/mm/yyyy'))"}>}FieldName)
and continue to use Date1 as your dimension.