Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have date field and Actual values
here i want to show only data Upto Today() means Feb-15. Cutoff the values after feb-2015.
how to write this in set analysis
i need this in front end only
Thanks,
Hi,
It is better you use date format in the script and then use in the chart
Ex:-
T1:
LOAD Date,
[Actual Site Activation]
FROM
j1.xlsx.xls
(biff, embedded labels, table is Sheet1$);
NoConcatenate
LOAD
Date(date#(Date,'MMM-YY'),'MMM-YY') as DateField,
[Actual Site Activation]
Resident T1;
DROP Table T1;
And in charts
Dim:- DateField
Expre:- =Sum({$<DateField = {'<=$(=(Date(MonthName(Today()),'MMM-YY')))'}>} [Actual Site Activation])
Regards,
Anand
May be like this:
Sum({<Date = {'<= $(=Date(Today(), 'yourDateFormat')'}>} [Actual Site Activation])
You will need to make sure that the format of the yourDateFormat matches the format of Date in your database.
HTH
Best,
S
Hi,
You can use where function inside where use month function to pick current month.
hi sunindia,
please find the sample application
Hi,
Then write SET expression as
=Sum({$<DateField = {'<=$(=(Today()))'}>} [Actual Site Activation])
Regards,
Anand
please find the attachment.
Hi,
Check the attached solution file.
And write
=Sum({$<Actual = {'<=$(=(Today()))'}>} value)
Regards,
Anand
Hi Please find related Sample
Thanks in advance
if you want to include date until end of month, feb-2015
=Sum({$<Actual = {"<=$(=(MonthEnd(Today())))"}>} value)
Here try this as your expression:
=Sum({<Actual = {'<=$(vToday)'}>} value)
here vToday =Date(Today(), 'M/D/YYYY')
PFA the application also.
Best,
S