Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

julruiz123
Not applicable

Problem to compare in pivot table

Hi!

I have a pivot table that compares the billing of the month with the month above, but it doesn't works to compare january with december of the previos year.

This is the expression used

([Facturación] - Below([Facturación])) / Below([Facturación])

How i can resolve that ??

img.png

Tags (2)
1 Solution

Accepted Solutions
julruiz123
Not applicable

Problem to compare in pivot table

Solved!

([Facturación] - Below(TOTAL [Facturación])) / Below(TOTAL [Facturación])

1 Reply
julruiz123
Not applicable

Problem to compare in pivot table

Solved!

([Facturación] - Below(TOTAL [Facturación])) / Below(TOTAL [Facturación])