how to get only those records where amount > xyz

[Anonymous]

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

[sunny_talwar · Accepted solution]

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)

[Anonymous]

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

[sunny_talwar]

In a straight table, right?

Dimension

cheque number

Expression

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

[Anonymous]

sunny what should be the measure here

Thanks

[sunny_talwar]

Whatever you are trying to sum I guess