Filter for date column to get last 3 months from max date in table

[Luis_Arocho-LLantin]

Is it possible for a  filter condition to use only last 3 months of the Data from the max date of the date column in table?

Thanks in advance

[rubenmarin]

Hi, it should be possible, it could be something like:

Sum({<DateField={">=$(=AddMonths(Max(Date),-3))<=$(=Max(Date))"}>} Value)

[Luis_Arocho-LLantin]

Hi Ruben

The customer tried the formula but it gave her an error in the editor.

[rubenmarin]

Hi Luis, that looks like Replicate or some other tool outside QlikSense, so Qlik script syntax won't work.

I don't have the experience to tell the expression without making tests and I don't have access now to that tool. It could be something like:

$START_TRAN_DATE>Date(Max($START_TRAN_DATE),'-3 months')

But I'm not sure at all if this can work.

Check on the forum dedicated to that tool: Qlik Integration -> Replicate/Composer, this one is for QlikSense. 

Regards