# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor

## Less than statement with a measure.

I'm trying to edit the following expression/measure to show only payment amounts less than -\$20.00.

Column/Measure: Tx Payment Amt

Expression: Sum({< [Tx Payment Flag] = {1} >}[Tx Amt])

Tags (3)
5 Replies
Esteemed Contributor

## Re: Less than statement with a measure.

Hi,

try this:

=Sum({< [Tx Payment Flag] = {1},[Tx Amt]={"=sum([Tx Amt])<-20"} >}[Tx Amt])

Honored Contributor III

## Re: Less than statement with a measure.

May be use an if

Sum({< [Tx Payment Flag] = {1} >} If([Tx Amt]<-20,[Tx Amt],0))

New Contributor

## Re: Less than statement with a measure.

Thank you that worked! Now, I would like to exclude any Tx Payment Amt = 0  along with the current parameter.  No matter what I try, I'm still showing 0.00 values in my output.

Partner

## Re: Less than statement with a measure.

Hi,

Just to confirm are Tx Payment Amt and [Tx Amt] different fields?

If so then

Sum({< [Tx Payment Flag] = {1}, [Tx Payment Amt]={'> 20'}>}[Tx Amt])

Mark

New Contributor

## Re: Less than statement with a measure.

So, Tx Payment Amt is the field/measure I am pulling into my table.  Tx Amt is a separate dimension that exists in the expression for Tx Payment Amt.

The expression for this measure which is constructed by a development team is:

Sum({< [Tx Payment Flag] = {1} >}[Tx Amt])

I would like to edit this expression so the Tx Payment Amt column pulls values less than -\$20.00 and not equal to 0.00.

The following expression pulls Tx Payment less than -20.00 but I'm still showing values equal to 0.00.

Sum({< [Tx Payment Flag] = {1} >} If([Tx Amt]<-20,[Tx Amt],0))