Pivot table calculations

aetingu12 — Sat, 16 Nov 2024 04:44:46 GMT

Dear all,

Is there a way to add calculated columns on a pivot table? ie I have one dimension of products and one dimension of dates and an expression of sales.

The products are the first columns, dates are across on the top giving me the sales by date. On the very last columns following the latest date, I want to calculate a movement between the latest available date (in dimension) and the prior one.

So I would like to be able to show the historic sales plus the latest change.

Here is the code:

LOAD * INLINE [
    Product, Date, Sale
    A, 31/01/2019, 100
    B, 28/02/2019, 150
    A, 28/02/2019, 50
    B, 31/01/2019, 200
    A, 31/03/2019, 50
    B, 31/03/2019, 200  
];

Pivot table:

Ask is:

Is this doable?

Regards,

Re: Pivot table calculations

shiveshsingh — Wed, 16 Jan 2019 11:30:24 GMT

Please share sample data and expected output.

Re: Pivot table calculations

aetingu12 — Wed, 16 Jan 2019 11:39:22 GMT

Just added an excel image to explain the output

topic Pivot table calculations in QlikView

Pivot table calculations

Re: Pivot table calculations

Re: Pivot table calculations