# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Highlighted
New 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

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

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

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

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)

New Contributor

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

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

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

In a straight table, right?

Dimension

cheque number

Expression

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

New Contributor

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

sunny what should be the measure here

Thanks

MVP

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

Whatever you are trying to sum I guess