Count all tickets past 6 months

[codyt97]

Hello. I'm new to Qlik and I need some help.

I have 2 fields 'CREATEDATE' and 'CaseNumber'. I would like to count  CaseNumbers for past 6 months form today based on Createdate. Createdate field have this format YYYY-MM-DD

[Almen]

You can try in script:

12*Year(Today())+Month(Today())-12*Year(CREATEDATE)-Month(CREATEDATE) AS MonthsAgo 

it gives you a full coverage of all months ago. Select 6 to get 6 months ago, based on today().