topic Re: Pivot table filter on expression subtotals using list box in QlikView

Pivot table filter on expression subtotals using list box

Tue, 28 Jul 2015 22:09:15 GMT

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

Re: Pivot table filter on expression subtotals using list box

marcus_sommer — Wed, 29 Jul 2015 11:22:42 GMT

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

Re: Pivot table filter on expression subtotals using list box

Gysbert_Wassenaar — Wed, 29 Jul 2015 13:30:56 GMT

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