Select in Field - inserting a function

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

Hi Experts,

I'd like to only select rows (via a button) that satisfy a function. I first have a variable (vTestVariable) in a slider object for the user to select anywhere from 0-100. Upon clicking the button, it should only select ID's where the function below is satisfied:

Value where Type=A minus Value where Type=B should be >= vTestVariable

The table of data I am working with resembles below:

ID	Value	Type
ABC100	60	A
ABC100	10	B
DEF999	90	A
DEF999	80	B

So if vTestVariable = 30 and the button is pressed, only ID=ABC100 should in the selection because 60-10>=30. DEF999 should not be part of selection because 90-80 < 30. Any ideas how I can implement this? I was trying to use "Select in Field" Action but finding it tricky what field to put and what search string is.

Thanks!

Re: Select in Field - inserting a function

sunny_talwar — Tue, 17 Jul 2018 12:22:39 GMT

Try this as search string

='=Sum({<Type = {"A"}, ID>} Value) - Sum({<Type = {"B"}, ID>} Value) >= vTestVariable'

topic Select in Field - inserting a function in QlikView

Select in Field - inserting a function

Re: Select in Field - inserting a function