Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ShirSandoval
Creator
Creator

MONTHSAGO - TODAY()-1

Buenas noches comunidad, tengo la siguiente expresión: y necesito mostrar en un KPI Rate del día anterior y otro KPI con Rate del Mes. Cree variables v_today()-1 pero no me funciona. Espero me puedan dar una mano y se entienda mi consulta.  

RATE($(CUOTA_NPER), SUM ($(CUOTA_PMT)), -$(CAPITAL),0)*12/1.21

Labels (1)
2 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

Can you ask the question in English maybe? Then I can try to solve your issue.

Jordy

Climber

Work smarter, not harder
ShirSandoval
Creator
Creator
Author

Good evening Jordy, I have the following expression: and I need to show in a KPI Rate of the previous day and another KPI with Rate of the current Month. I Create variables v_today () - 1  but it doesn't work for me. I hope you can give me a hand and my query is understood. 

My date field is Transdate and format 'D / M / YYYY'

expression: RATE($(CUOTA_NPER), SUM ($(CUOTA_PMT)), -$(CAPITAL),0)*12/1.21