How to select only lines with greater than 1k value in a file

[#1]

Hi All,

I am new to Qlikview and trying to find my ground here. Hoping that some one will be able to help me with the below

Anything that is greater than age 7 and value>=1000 should be picked up/ highlighted in a BAR chart.

Name	type	Age	value
Sammy	credit	1	1000
Sarala	debit	1	600
Andy	debit	2	100
Martin	credit	3	100
Sarala	debit	5	1000
Vijaya	credit	6	1010
Vijaya	credit	6	1020
Sammy	credit	7	1500
Sravs	credit	7	1600
Sammy	credit	7	100
Andy	debit	8	1200
Andy	debit	8	1300
Martin	debit	9	1600
Martin	credit	9	100
Sammy	credit	10	90
Andy	debit	11	1080
Martin	debit	12	1180
Sravs	credit	13	60

Thanks for your help in advance.

[johnw]

Not clear what you're doing with two dimensions. Are debits subtracted from credits to get the final total, and that total is what we're showing if >=1000? Maybe something like this?

types:
LOAD * INLINE [
type,sign
credit,+1
debit,-1
];

Dimension = Name
Expression = if(sum({<Age={">7"}>} sign*value)>=1000,sum({<Age={">7"}>} sign*value))

But I could easily have misunderstood what you're after.