topic inputbox values calculation in QlikView

inputbox values calculation

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

i have data as below

employee_id salary age

1 50 25

2 60 32

3 25 25

4 120 20

5 150 45

i need to have 2 inputboxs where if i give a value 100 in Salary input box and 25 in Age input box

it should calculate me the values whose salary is less than 100 and age equal to 25

so my output here is

employee_id salary age

1 50 25

3 25 25

vishsaggi — Thu, 01 Dec 2016 21:09:16 GMT

May be try this?

SalaryInput is your first Inputbox

AgeInput is your Age inputbox.

Using straight table:

Dim: = IF( salary < SalaryInput AND age = AgeInput, employee_id)

Expr: = Salary

= Age

sinanozdemir — Thu, 01 Dec 2016 21:25:49 GMT

Hi,

You can use something similar to the attached:

Thanks

neelamsaroha157 — Thu, 01 Dec 2016 21:29:07 GMT

Is this what you are looking for

Sun, 04 Dec 2016 14:40:35 GMT

Thank you so much your answers solved the problem