Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear sir ,
For the hint purpose , I plan to sum total amount in Text Object , and , the amount date is before or after a certain date. Please kindly help to guide me the expressions syntax. Thanks.
if you have that date in a variable ex. $(Dt)
=Sum({$ <mydate={'>=$(DT)'}>} TOTAL Amount)
Let me know
if you hard code the date:
After and including a date:
=Sum({<Date={">=01.01.2014"}>}Amount)
Before and including:
=Sum({<Date={"<=01.01.2014"}>}Amount)
Between and including:
=Sum({<Date={">=01.01.2014<=31.01.2014"}>}Amount)
To not include the ends, remove the equal signs (=).
The format of the date might be sensitive to the way a date is specified in the start of your load script, but I have not tested this.
Regards
SKG
Thank you sir. The community support is helpful for my self study Qlikview.
Thank you sir. It is great helpful for my self study Qlikview.