Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Evaluate different dates in a expression

Hello, I wanna make a expression in a Pivot Table, where there is only one dimension, Date.

The expression is a division between the balance today and the total balance 2 months ago.

The field Date is for any date, and Date_2 is a date 2 month before Date.

This is the expresion made:

sum(Aggr(sum( {<cod_Situation = {3} >} BuvBalance), Date))/

sum(Aggr(sum( {<cod_Situation = {1, 2, 3, 4, 5, 6, 7, 8, 9} >} BuvBalance), Date_2))

The problem is that the expression can not evaluate correctly Date_2, and the dividend does not work correctly.

In fact, looks like it evaluate Date_2 as Date.

Thanks for any help!

10 Replies
sebastiandperei
Specialist
Specialist

Ok, si funcionó, marcá el post como respondido, así se cierra.