# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:  Contributor

## how to get only those records where amount > xyz

Hi I am new to qlikview , I am trying to create a list of records(cheque numbers) where refund amount >500

in doing so I am not getting any values as in the straight table created by me. So my question is would object "straight table" the best choice for doing this and if yes how should I do it

I did some calculation in the expression for dimension cheque number

If(FABS( REF_AMT>='500'),cheque number)

but this is giving me null.

It would be very helpful for me if somebody could provide any help on this

1 Solution

Accepted Solutions  MVP

I think you have incorrectly placed your parenthesis... try this

If(fabs(REF_AMT) >= 500, cheque number)

But instead of using a calculated dimension, may be you want to use set analysis within your expression

Sum({<REF_AMT = {">=500", "<=-500"}>}Measure)

5 Replies  MVP

I think you have incorrectly placed your parenthesis... try this

If(fabs(REF_AMT) >= 500, cheque number)

But instead of using a calculated dimension, may be you want to use set analysis within your expression

Sum({<REF_AMT = {">=500", "<=-500"}>}Measure)  Contributor
Author

HI SUNNY,

Thanks for the response but the problem is that I don't want the sum of the ref amount, I want the cheque numbers where abs value of ref_amount> 500

I hope I am making sense  MVP

In a straight table, right?

Dimension

cheque number

Expression

Sum({<REF_AMT = {">=500", "<=-500"}>}Measure)  Contributor
Author

sunny what should be the measure here

Thanks  MVP

Whatever you are trying to sum I guess 