Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jdpost97
New Contributor

Comparing a date within a range

Hey everyone,

I am trying to sum all values that have a reporting date with the last 3 months. I am looking for only charges, [TX Type] = {'C'}. Is there a way to say:

Reporting Date > AddMonths(Date(now(0))),-3)


This is the expression I currently have, obviously with the Reporting Date bit missing.

sum(

      {<

       [TX Type] = {'C'}

       ,[Reporting Date]  = _?_?_?_?_?_?_?_?_?_

      >} [Amount])


Thanks so much.

Tags (1)
2 Replies

Re: Comparing a date within a range

Perhaps this?

sum({< [TX Type] = {'C'} ,[Reporting Date]  = {"$(=AddMonths(Date(now(0)),-3))"} >} [Amount])

marinadorcassio1
Contributor

Re: Comparing a date within a range

Hi,


More precisely, I think :

sum({< [TX Type] = {'C'} ,[Reporting Date]  = {" > $(=AddMonths(Date(now(0)),-3))"} >} [Amount])