Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Adding % Difference to Previous Period (Year / Month / Qtr) into Pivot Table

Hi.

I have set up a pivot table that has Year, Quarter and Month as Rows and measures:

Number of Parties   - Sum([BubAdm_Number of Parties])

Party Children         - Sum(BubAdm_PartyPeople)

Average Party Price     - Sum([Party Income from Days Parties])/Sum([BubAdm_Number of Parties])

Average Spend per child      -  Sum([Party Income from Days Parties])/Sum(BubAdm_PartyPeople)

I want to add a column next to each existing column that shows the difference and % difference to previous year for each figure.

I've no idea where to start on this sorry.

1 Reply
Not applicable

Re: Adding % Difference to Previous Period (Year / Month / Qtr) into Pivot Table

Hi all, I'm assuming it's not possible to do this then?