topic Adding data from previous column in pivot table in App Development https://community.qlik.com/t5/App-Development/Adding-data-from-previous-column-in-pivot-table/m-p/1594125#M43697 <P>&nbsp;</P><P>HI Experts</P><P>The Category and month are my dimension and Count of Category is the measure below is the table i got after calculation and Pivoting.</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>MonthYear</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Category</TD><TD>Totals</TD><TD>May-19</TD><TD>Jun-19</TD><TD>Jul-19</TD><TD>Aug-19</TD><TD>Jun-20</TD></TR><TR><TD>B1</TD><TD>4</TD><TD>-</TD><TD>3</TD><TD>1</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B2</TD><TD>4</TD><TD>1</TD><TD>-</TD><TD>3</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B3</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>1</TD></TR><TR><TD>C1</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>D1</TD><TD>2</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the below calculation as in the table&nbsp;</P><TABLE><TBODY><TR><TD>Category</TD><TD>Totals</TD><TD>May-19</TD><TD>Jun-19</TD><TD>Jul-19</TD><TD>Aug-19</TD><TD>Jun-20</TD></TR><TR><TD>B1</TD><TD>4</TD><TD>(Show the Pevious column if Null in this case 4)</TD><TD>3</TD><TD>1</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B2</TD><TD>4</TD><TD>1 (Subtract with previous column if there is a value in this case 4-1=3)</TD><TD>-</TD><TD>3</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B3</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>1</TD></TR><TR><TD>C1</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>D1</TD><TD>2</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>and the result table i intend to get should be like below.</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>MonthYear</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Category</TD><TD>Totals</TD><TD>May-19</TD><TD>Jun-19</TD><TD>Jul-19</TD><TD>Aug-19</TD><TD>Jun-20</TD></TR><TR><TD>B1</TD><TD>4</TD><TD>4</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>B2</TD><TD>4</TD><TD>3</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>B3</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>C1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>D1</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can someone help me, please.</P> Sat, 16 Nov 2024 20:37:23 GMT vpanchuda 2024-11-16T20:37:23Z Adding data from previous column in pivot table https://community.qlik.com/t5/App-Development/Adding-data-from-previous-column-in-pivot-table/m-p/1594125#M43697 <P>&nbsp;</P><P>HI Experts</P><P>The Category and month are my dimension and Count of Category is the measure below is the table i got after calculation and Pivoting.</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>MonthYear</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Category</TD><TD>Totals</TD><TD>May-19</TD><TD>Jun-19</TD><TD>Jul-19</TD><TD>Aug-19</TD><TD>Jun-20</TD></TR><TR><TD>B1</TD><TD>4</TD><TD>-</TD><TD>3</TD><TD>1</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B2</TD><TD>4</TD><TD>1</TD><TD>-</TD><TD>3</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B3</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>1</TD></TR><TR><TD>C1</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>D1</TD><TD>2</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the below calculation as in the table&nbsp;</P><TABLE><TBODY><TR><TD>Category</TD><TD>Totals</TD><TD>May-19</TD><TD>Jun-19</TD><TD>Jul-19</TD><TD>Aug-19</TD><TD>Jun-20</TD></TR><TR><TD>B1</TD><TD>4</TD><TD>(Show the Pevious column if Null in this case 4)</TD><TD>3</TD><TD>1</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B2</TD><TD>4</TD><TD>1 (Subtract with previous column if there is a value in this case 4-1=3)</TD><TD>-</TD><TD>3</TD><TD>-</TD><TD>-</TD></TR><TR><TD>B3</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>1</TD></TR><TR><TD>C1</TD><TD>1</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR><TR><TD>D1</TD><TD>2</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD><TD>-</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>and the result table i intend to get should be like below.</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>MonthYear</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Category</TD><TD>Totals</TD><TD>May-19</TD><TD>Jun-19</TD><TD>Jul-19</TD><TD>Aug-19</TD><TD>Jun-20</TD></TR><TR><TD>B1</TD><TD>4</TD><TD>4</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>B2</TD><TD>4</TD><TD>3</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>B3</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>C1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>D1</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can someone help me, please.</P> Sat, 16 Nov 2024 20:37:23 GMT https://community.qlik.com/t5/App-Development/Adding-data-from-previous-column-in-pivot-table/m-p/1594125#M43697 vpanchuda 2024-11-16T20:37:23Z