Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Date Filter and I want to make my set expression like this.
If we select Year = 2017, Month = March then we will have dates will be 1st March to 10 march.
If i select any date it will show value for till that date.
My expression is below:
Count({<DT={'=<$(v2)'}>}OrderLineDueCount).
But this is not working.
I am attaching my qvw file.
Could you please check and help to resolve.
Thanks,
Sarif
65 MG is file size.. WOW
Count({<DT = {'$( '<=' & =Max(DT))'}, Year = {'$(=Max(Year))'}>} OrderLineDueCount)
Or
Count({<DT = {"<= $(=Max(DT))"}, Year = {'$(=Max(Year))'}>} OrderLineDueCount)
Try this
=Count({<DT={'<=$(=$(v2))'}>}OrderLineDueCount)