topic Expression help in QlikView

Expression help

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following expression that is unfortunately not working.

Does anyone have any idea what the issue might be?

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'},ReportDate={"$(DATE#(FirstWorkDate(today(),2)'DD/MM/YYYY')"}>}DTLS_AMOUNT)

Thanks,

Daniel

MK_QSL — Tue, 29 Nov 2016 10:11:46 GMT

Try

SUM({<

DTLS_PAYMENT_RECEIPT_IND={'R'},

ReportDate = {"$(=Date(FirstWorkDate(Today(),2),'DD/MM/YYYY'))"}

>}DTLS_AMOUNT)

danielnevitt — Tue, 29 Nov 2016 10:42:39 GMT

Thanks for your help