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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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?