Expressions in Text Object

[#1]

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.

[alexandros17]

if you have that date in a variable ex. $(Dt)

=Sum({$ <mydate={'>=$(DT)'}>} TOTAL Amount)

Let me know

[simenkg]

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

[#4]

Thank you sir. The community support is helpful for my self study Qlikview.

[#5]

Thank you sir. It is great helpful for my self study Qlikview.