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: 
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