Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Table 1:
id orderdate sales year
1 01/02/2001 100 2001
2 01/02/2002 200 2002
3 01/02/2003 300 2003
4 01/02/2004 400 2004
Now i want load only "01/02/2003" below data.
I want write this filter condition in set analysis expression and filter must be a variable.
Regards
Suresh
=sum({$<OrderDate={"<=$(datefilter)"}>} Sales)
so add a WHERE statement at the end
Table 1:
id orderdate sales year
1 01/02/2001 100 2001
2 01/02/2002 200 2002
3 01/02/2003 300 2003
4 01/02/2004 400 2004
WHERE orderdate = '01/02/2003';
try below in set analysis:
sum({1<orderdate = {">= 01/02/2003 "}>} sales)
Thank you for your reply,
ex: let vdatefilter=makedate(2003,02,01);
then use this variable in SetAnalysis as a filter
I want write filter condition in SetAnalysis and filter must be a variable
Regards
Suresh
HI
Try like this
Now i want load only "01/02/2003" below data:
= sum({1<orderdate = {"<01/02/2003"}>} sales)
Edit:
PFA
Note:
If you need to load only data upto "01/02/2003", then you can go with Allan
Why SET Analysis? the solution from Alan Ferrel is correct!!! and more sample!!
=sum({$<OrderDate={"<=$(datefilter)"}>} Sales)