Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

How to use both expression in single Straight table?

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.

new doubts1.png

4 Replies
gireesh1216
Creator II
Creator II
Author

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)


Capture.PNG

gireesh1216
Creator II
Creator II
Author

ok i will try sunny