Select records based on result of expression using slider

[#1]

Hi All

I have customer data in a Qlikview app where we have:

Customer, Date, value, delta

e.g.

Customer1, 01/01/2009, 100, 0

Customer1, 01/02/2009, 75,-25

Customer1, 01/03/2009, 50,-25

Customer1, 01/04/2009, 25,-25

Customer2, 01/01/2009, 100, 0

Customer2, 01/02/2009, 90,-10

Customer2, 01/03/2009, 80,-10

Customer2, 01/04/2009, 70,-10

I want to be able to select all customers based on date period and the sum of delta over that period, using a slider to make this selection.

So if I have my date range set to 01/01/2009->01/03/2009 and my slider is set to 50, only Customer1 will be selected.

I can use an expression in a table to calculate the sum of the delta per customer,

So for the date range 01/01/2009->01/03/2009 I would have

Customer, sum of delta expression

--------------------------------

Customer1, -50

Customer2, -20

How do I then wire up the slider to select customers in this table that have the expression value=slider value.

Can anyone suggest an approach to accomplish this. I've tried various things but have drawn a blank.

Kind regards

[#2]

Hello,

I actually habe the same problem/challenge. Tried to solve it with a bookmark that selects customers and the bookmark contains the calculation of the variables which come from the sliders. but this means that you alsways have to select the bookmark.

Keep me posted if you have news on this.

Felix

[johnw]

One way is to use <Expression> for the slider, and set the expression to =aggr(sum({<Customer=>}delta),Customer). See attached.

[#4]

John,

thanks, that works great! Actually I have two sliders for setting the limits that should apply for the selection in Customers. So I just left out the {<Customer=>} statement so that the current selection can be further be narrowed down...

Thanx alot.

Felix

[#5]

That's great John, Many thanks for this.

Mike