Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon, folks!
I'm trying to calculate the minimum between two dates in a KPI script but I'm facing some errors.
I tried the following:
Hi, @QFabian , I tried what you suggested but where Date=data_final+tamanho_durante, but I couldn't reach the expected result...
Fortunately, I was able to find the solution using RangeMin instead of Min:
=RangeMin(Date#('18/02/2021','DD/MM/YYYY'),num(data_final)+tamanho_durante)
Thanks for your support!
Hi @QFabian this works here, Qlik understands it and gives back the correct date.
But the problem is that I want to calculate the mininum date between this variable date (data_final+tamanho_durante) and a fixed date '18/02/2021'.
Do you know how I could do this?
Hi @doublepsa , i just created this and works, please check your date separator, in my case '-'
Hi, @QFabian , I tried what you suggested but where Date=data_final+tamanho_durante, but I couldn't reach the expected result...
Fortunately, I was able to find the solution using RangeMin instead of Min:
=RangeMin(Date#('18/02/2021','DD/MM/YYYY'),num(data_final)+tamanho_durante)
Thanks for your support!