Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variation of income by family month by month

Dear,

I need to find out:

      If the analyzed family had the income altered from one month to the other,

Was varied, and varied positively,

Was varied, and negatively varied.

It did not work: above function, nor previus.

Thank you!

4 Replies
sunny_talwar

May be you need Before here?

=((sum(vlr_renda)/Before(sum(vlr_renda)))-1)*100

sunny_talwar

Read about Before and After here:

Missing Manual - Before() and After()

Not applicable
Author

Thanks for your response, but it's not work because I need consider the date before (not the column before).

sunny_talwar

What is the output that you are expecting to see?