topic Re: How to use both expression in single Straight table? in QlikView

How to use both expression in single Straight table?

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to use both expression in single Straight table?

gireesh1216 — Sun, 18 Sep 2016 07:55:59 GMT

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

Re: How to use both expression in single Straight table?

sunny_talwar — Sun, 18 Sep 2016 23:27:05 GMT

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

Re: How to use both expression in single Straight table?

sunny_talwar — Sun, 18 Sep 2016 23:39:08 GMT

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)

Re: How to use both expression in single Straight table?

gireesh1216 — Mon, 19 Sep 2016 12:47:18 GMT

ok i will try sunny