Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Fechas Qlik Sense

Buenos días, tengo un campo Fecha con el formato DD/MM/YYYY y necesito quedarme con fechas de 4meses hacia atrás desde la fecha actual. Alguna idea de como se puede hacer?

Un saludo y gracias

Labels (3)
3 Replies
Highlighted
Partner
Partner

Hi,

Try this, it will add four months.

AddMonths([YourDateField],4)

Jordy

Climber 

Work smarter, not harder
Highlighted
Partner
Partner

Good morning,

the solution is incorrect.

I need to stay as of today with all dates 4 months ago maximum.

Thanks!!!

Highlighted
Partner
Partner

if([User Acces Last Used] < AddMonths(Today(),-3, [User Acces Last Used], -3))