topic creating a delta column based on selection dates in a pivot chart in QlikView

creating a delta column based on selection dates in a pivot chart

nburton78 — Wed, 12 May 2021 14:35:36 GMT

I am looking to add a total to my pivot chart that calculates the change from the latest date selected to the earliest date selected. Right now I have it so that it calculates but only in another table.

Is there a way to make this happen in one table? like this:

Sales_Person	Month	4/1/2021	5/1/2021	Change
Anne		6	20	14
Bob		10	18	8
Carol		18	16	-2

Re: creating a delta column based on selection dates in a pivot chart

Gysbert_Wassenaar — Wed, 12 May 2021 15:41:02 GMT

What you want is not possible in a pivot table. You can only have columns for every dimension value. It's not possible to add custom columns to the pivot table

Re: creating a delta column based on selection dates in a pivot chart

nburton78 — Thu, 13 May 2021 17:46:52 GMT

thanks, I was hoping it was possible, I guess not.