Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis totals

Hi,

I am  using the below expression to calculate the sum in a text box  but it is not returning the correct sum.

Sum({<[Billing Transaction Datetime]={"<=$(=Timestamp(Today()))"}>}[Billing Disbursement Amount])

The sum I am getting with this expression is -99 which is incorrect as per the data in below image.

ImageTest.png

Please help me with the same.

Regards,

Manu

1 Reply
sunny_talwar

What is the correct you are expecting to see? Would you be able to share a sample?