Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My Requirement:If I Select one employee id and date filters want to show only employee data based on date filters.
.................................................
--->If i select one employee id want to show employee id related data based on Date filters.1st table i am using 1st expression("").
--->Second table i am using the 2nd expression(Date filters Expression).
--->3rd table i am using Both expressions(1st and 2nd).This 1st and 2nd expressions are working separately.But both this expression are not working in last table.
Please find below image,qvw document and data.
only function and date filter function not working at a time in 3rd table.
It seems to be working pretty well, what do you expect to see in the 3rd table? May be if you can point out what is missing, we might be able to help you better
Are you looking to see all EmployeeID regardless of selection which are between the vMax and vMin variables? May be this:
=Sum({$<OrderDate={">=$(vMin)<=$(vMax)"}, EmployeeID>} Sales)
ok i will try sunny