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: 
marcia_ribeiro
Contributor II
Contributor II

scrolling of the wallets

Hello,

I need to set up a panel with the scrolling of the wallets according to level and date ... but I can not.
I need to get the value of "D" in month 6/2007 and divide by the value of "C" of the month 5/2007, for example

9 Replies
settu_periasamy
Master III
Master III

Sample would be helpful to try and the expected output..

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Do you want those subtractions happening from arbitrary cells from the pivot table, because that may prove a bit problematic. Are there any business rules we can apply for these calculations, or do you want to be able to simply select row X column Y and row A column B?

marcia_ribeiro
Contributor II
Contributor II
Author

I put a non-template to help ...
el_aprendiz111
Specialist
Specialist

Hi,

FIELD2/ABOVE(FIELD1)

marcia_ribeiro
Contributor II
Contributor II
Author

Hi, I tried this formula ... but he does not understand that I have to compare the two databases but the account is made in relation to the levels of letter ... ex feb x jan balance of "C" in feb on balance of "B" In Jan

el_aprendiz111
Specialist
Specialist

Hi Marcia

Would you be able to share a sample with the expected output? (qvw)

marcia_ribeiro
Contributor II
Contributor II
Author

Yes I'll post

el_aprendiz111
Specialist
Specialist

Hi

el_aprendiz111
Specialist
Specialist

Hi