https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1621742#M734644 <P>Can anyone please help&nbsp;</P> Mon, 09 Sep 2019 20:13:02 GMT santharubban 2019-09-09T20:13:02Z https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1621740#M734643 <P>Please find the attachment</P><P>This Data:</P><TABLE><TBODY><TR><TD><P><STRONG>Program Milestone</STRONG></P></TD><TD><P><STRONG>Control Model</STRONG></P></TD><TD><P><STRONG>Commodity</STRONG></P></TD><TD><P><STRONG>Cost</STRONG></P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part A</P></TD><TD><P>($78.36)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part A</P></TD><TD><P>0</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>($44.31)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>0</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>($1.98)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>($0.98)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>$0.02</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>($13.32)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>($6.16)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part B</P></TD><TD><P>($9.57)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part C</P></TD><TD><P>($5.55)</P></TD></TR><TR><TD><P>Program 1</P></TD><TD><P>C1</P></TD><TD><P>Part C</P></TD><TD><P>($5.44)</P></TD></TR><TR><TD><P>Program 2</P></TD><TD><P>C2</P></TD><TD><P>Part A</P></TD><TD><P>($58.30)</P></TD></TR><TR><TD><P>Program 2</P></TD><TD><P>C2</P></TD><TD><P>Part B</P></TD><TD><P>($0.15)</P></TD></TR><TR><TD><P>Program 2</P></TD><TD><P>C2</P></TD><TD><P>Part B</P></TD><TD><P>($0.15)</P></TD></TR><TR><TD><P>Program 2</P></TD><TD><P>C2</P></TD><TD><P>Part B</P></TD><TD><P>($5.41)</P></TD></TR><TR><TD><P>Program 2</P></TD><TD><P>C2</P></TD><TD><P>Part B</P></TD><TD><P>($15.02)</P></TD></TR><TR><TD><P>Program 3</P></TD><TD><P>C3</P></TD><TD><P>Part B</P></TD><TD><P>($12.96)</P></TD></TR><TR><TD><P>Program 3</P></TD><TD><P>C3</P></TD><TD><P>Part B</P></TD><TD><P>($5.16)</P></TD></TR><TR><TD><P>Program 3</P></TD><TD><P>C3</P></TD><TD><P>Part B</P></TD><TD><P>($8.57)</P></TD></TR><TR><TD><P>Program 3</P></TD><TD><P>C3</P></TD><TD><P>Part C</P></TD><TD><P>($6.55)</P></TD></TR><TR><TD><P>Program 3</P></TD><TD><P>C3</P></TD><TD><P>Part C</P></TD><TD><P>($4.44)</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks</P><P>KSS</P> Sat, 16 Nov 2024 02:31:39 GMT https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1621740#M734643 santharubban 2024-11-16T02:31:39Z https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1621742#M734644 <P>Can anyone please help&nbsp;</P> Mon, 09 Sep 2019 20:13:02 GMT https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1621742#M734644 santharubban 2019-09-09T20:13:02Z https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1622178#M734645 <P>Something like this?</P><P><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/18862i7AF47B8167017238/image-size/large?v=1.0&amp;px=-1" border="0" width="702" height="99" title="image.png" alt="image.png" /></P> Tue, 10 Sep 2019 14:23:09 GMT https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1622178#M734645 sunny_talwar 2019-09-10T14:23:09Z https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1622645#M734646 <P>Thanks Talwar.</P><P>Yes, this will also worked, but i have figured out a simple this solution.&nbsp;</P><P><U>Expression 1:</U></P><P>Sum(Cost)</P><P><U>Expression 2 :</U></P><P>Sum(cost) - First(Sum(cost))&nbsp; which will give a delta.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 11 Sep 2019 13:29:54 GMT https://community.qlik.com/t5/QlikView/Delta-on-Pivot-Table/m-p/1622645#M734646 santharubban 2019-09-11T13:29:54Z