How to use both expression in single Straight table?

[gireesh1216]

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.

[gireesh1216]

only function and date filter function not working at a time in 3rd table.

[sunny_talwar]

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

[sunny_talwar]

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)

[gireesh1216]

ok i will try sunny