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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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.