Filter Single Value to display

[BrianDH]

Within my Qlik sheet/Table object

I need to show a single refund value based on filters. 

Example: =If(Bank_At_Flag = 'RFND', if(Paid_Amt <= 10.00, SUM(Paid_Amt)))

All I get in return is > - <.  

Using Qlik Sense browser based tool.

Thanks for the help!

B

[bharathadde]

Try this

=if(Paid_Amt <= 10.00, SUM({<Bank_At_Flag = {'RFND'}>}Paid_Amt))

[krishna_2644 · Accepted solution]

 SUM({<Bank_At_Flag = {'RFND'}, Paid_Amt  = {'<=10.00'}>}Paid_Amt)

This expression sums up all the paid amount where  Bank_At_Flag = 'RFND' with 'Paid_Amt<=10.00'

Hope that helps.

K

[BrianDH]

=SUM({}X_PAID_AMT)



I always get 0.



FYI: Validated with SQL my total should be ($1,258)

[BrianDH]

=if(X_PAID_AMT <= 10.00, Sum({}X_PAID_AMT))



I always get -.



FYI: Validated with SQL my total should be ($1,258)

[Yoshidaqlik · Accepted solution]

Hi,

Try:

SUM({<Bank_At_Flag = {'RFND'}, Paid_Amt  = {'<=10.00'}>} X_PAID_AMT)

Regards 

[BrianDH]

 That is it!! 🙂   Thank You!

[BrianDH]

I apologize, your code does work.  My bad!