topic Re: Expressions in Text Object in QlikView

Expressions in Text Object

Thu, 09 Oct 2014 07:46:51 GMT

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.

Re: Expressions in Text Object

alexandros17 — Thu, 09 Oct 2014 07:50:23 GMT

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

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

Let me know

Re: Expressions in Text Object

simenkg — Thu, 09 Oct 2014 07:51:33 GMT

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

Re: Expressions in Text Object

Thu, 09 Oct 2014 08:12:38 GMT

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

Re: Expressions in Text Object

Thu, 09 Oct 2014 08:13:47 GMT

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