Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
BrianDH
Contributor

Filter Single Value to display

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

Tags (4)
2 Solutions

Accepted Solutions
krishna_2644
Valued Contributor III

Re: Filter Single Value to display

 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

View solution in original post

Yoshidaqlik
Contributor II

Re: Filter Single Value to display

Hi,

Try:

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

 

 

Regards 

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng

View solution in original post

7 Replies
Highlighted
bharathadde
Contributor II

Re: Filter Single Value to display

Try this

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

krishna_2644
Valued Contributor III

Re: Filter Single Value to display

 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

View solution in original post

BrianDH
Contributor

Re: Filter Single Value to display

=SUM({}X_PAID_AMT)



I always get 0.



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

Re: Filter Single Value to display

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



I always get -.



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


Yoshidaqlik
Contributor II

Re: Filter Single Value to display

Hi,

Try:

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

 

 

Regards 

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng

View solution in original post

BrianDH
Contributor

Re: Filter Single Value to display

 That is it!! 🙂   Thank You!

BrianDH
Contributor

Re: Filter Single Value to display

I apologize, your code does work.  My bad!