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

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

Luis_Arocho-LLantin — Wed, 10 Nov 2021 14:36:12 GMT

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 — Wed, 10 Nov 2021 15:33:09 GMT

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

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

Luis_Arocho-LLantin — Thu, 11 Nov 2021 13:24:05 GMT

Hi Ruben

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

rubenmarin — Thu, 11 Nov 2021 14:28:16 GMT

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