Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

2 Replies
Anil_Babu_Samineni

Perhaps this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marinadorcassio1
Partner - Creator
Partner - Creator

Hi,


More precisely, I think :

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