Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
lastsamurai1097
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

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)

View solution in original post

5 Replies

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)

View solution in original post

lastsamurai1097
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

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)

Highlighted
lastsamurai1097
New Contributor

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

sunny what should be the measure here

Thanks

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

Whatever you are trying to sum I guess