Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot Table: Difference in Total column

Is there any chance to create a pivot table like the following?

Year

2008

2009

Difference

Expression 1

Value 1

Value 2

Diff 1 = Value 2 - Value 1

Expression 2

Value 3

Value 4

Diff 2 = Value 4 - Value 3

I would like to use one dimension (year) in the columns and several expressions in the rows. As total value I don't want to display the sum or one of the selectable in the table properties, I would like to show the difference.

Can anyone help?

Thanks in advance,

Susann.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Pivot Table: Difference in Total column

Here's one approach that merely pretends to be a pivot table.

3 Replies
Not applicable

Pivot Table: Difference in Total column

I'm guessing you need to use before().

Check attached QVW.

MVP
MVP

Pivot Table: Difference in Total column

Here's one approach that merely pretends to be a pivot table.

Not applicable

Pivot Table: Difference in Total column

Hi John,

that looks exactly like what I needed. Thanks for your example.

Best Regards,

Susann.

Community Browser