Pivot table filter on expression subtotals using list box

[#1]

I have a pivot table containing patients ID with each row representing the dates they were admitted to hospital as dimensions.My expressions contain the cost and for each attendance and a flag of 1 to representing an activity count to provide subtotals in the pivot. Can I filter on the pivot using a listbox to show the patients whose total cost exceeds a certain value or their total activity is greater than a selected number?

Many thanks

[marcus_sommer]

You could try it with an expression for the listbox like this:

=class(aggr(sum(cost), [patient ID]), 500)

which will cluster the cost in certain buckets - the value of 500 could be replaced by variable to get it more dynamically and you could of course use such expression as calculated dimension within your pivot.

- Marcus

[Gysbert_Wassenaar]

Maybe. Perhaps you can upload a qlikview document that demonstrates the questions. Use the Scramble feature to scramble any confidential information.