Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jpendergast022
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])

5 Replies
YoussefBelloum
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])

sasiparupudi1
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))

jpendergast022
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.

mark6505
Valued Contributor III

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

jpendergast022
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))

Community Browser