topic Re: Final user Filtering Results by Expression on Pivot Table in QlikView

Final user Filtering Results by Expression on Pivot Table

Tue, 26 Mar 2013 14:10:26 GMT

Hello,

I've a pivot table with 5 dimensions and one expression ( # of Hours). The Client is asking me to filter the result of the pivot table whatever he wants by the number of Hours.

E.g.

They want clicking the column header and writing " >3" in order to show only the records who have more than 3 hours.

The problem is that the expression column cannot be checked as Searchable on a Pivot Table.

I know, that i can switch from a Pivot Table to a Simple Table, and this would be resolved, but it would result losing the parcial totals by one of my dimensions.

Any idea how it can be solved?

Thanks a lot.

Albert.

Re: Final user Filtering Results by Expression on Pivot Table

Tue, 26 Mar 2013 14:12:42 GMT

Maybe an inbox would be the best option.

Re: Final user Filtering Results by Expression on Pivot Table

alexandros17 — Tue, 26 Mar 2013 14:13:25 GMT

Try to use an input box

Re: Final user Filtering Results by Expression on Pivot Table

Tue, 26 Mar 2013 14:30:24 GMT

Easy and fast. Thank you very much both of you.

Regards,

Albert.