topic Re: Calculating differences in pivot table in App Development

Calculating differences in pivot table

SudharshanK — Thu, 25 Jan 2024 16:49:05 GMT

How do we calculate the differences between columns in the pivot table? For instance, I want to compute the difference between Daily and Sep-23 for all the metrics A,B and C and put these differences in a single new column as shown in the attached screenshot. I am using qliksense saas.

Re: Calculating differences in pivot table

Digvijay_Singh — Fri, 26 Jan 2024 00:08:11 GMT

try column function as below -

https://community.qlik.com/t5/QlikView-App-Dev/How-to-operate-with-columns-in-a-pivot-table/td-p/145437

Re: Calculating differences in pivot table

anat — Fri, 26 Jan 2024 03:01:34 GMT

you can try like

Sep23 logic minus daily logic

Or column(1) -column (4)