topic Re: help on creating pivot table with formulas in QlikView https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1620559#M734731 <P>I found the solution.</P><P>DSUM in excel file can be written in qlik like this:</P><P><STRONG>=Sum({&lt;[DATE] = {'31/12/2018'}&gt;} [REVENUES])</STRONG></P> Thu, 05 Sep 2019 13:04:23 GMT maxronny 2019-09-05T13:04:23Z help on creating pivot table with formulas https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1617557#M734728 <P>i am not able to create a pivot table in qlikview.</P><P>1) i have an excel file imported in qlikview:</P><TABLE><TBODY><TR><TD>DATE</TD><TD>PROJECTCODE</TD><TD>REVENUES</TD><TD>COSTS</TD></TR><TR><TD>31/12/2018</TD><TD>3078</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.000,00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900,00</TD></TR><TR><TD>31/12/2018</TD><TD>3126</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.100,00</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 990,00</TD></TR><TR><TD>31/12/2018</TD><TD>3149</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.210,00</TD><TD>&nbsp;&nbsp;&nbsp; 1.089,00</TD></TR><TR><TD>31/12/2018</TD><TD>3169</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.452,00</TD><TD>&nbsp;&nbsp;&nbsp; 1.306,80</TD></TR><TR><TD>30/06/2019</TD><TD>3078</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.597,20</TD><TD>&nbsp;&nbsp;&nbsp; 1.437,48</TD></TR><TR><TD>30/06/2019</TD><TD>3126</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.395,80</TD><TD>&nbsp;&nbsp;&nbsp; 2.156,22</TD></TR><TR><TD>30/06/2019</TD><TD>3149</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.635,38</TD><TD>&nbsp;&nbsp;&nbsp; 2.371,84</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>2) in qlik view i wanna create these columns (red type) wih formulas but i am not able:</P><TABLE><TBODY><TR><TD>DATE</TD><TD>30/06/2019</TD><TD>30/06/2019</TD><TD>31/12/2018</TD><TD>31/12/2018</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">30/06/2019</FONT></TD><TD><FONT color="#FF0000">31/12/2018</FONT></TD><TD><FONT color="#FF0000">revenues 2019vs2018</FONT></TD><TD><FONT color="#FF0000">costs 2019vs2018</FONT></TD><TD><FONT color="#FF0000">profit/loss 2019vs2018</FONT></TD></TR><TR><TD>PROJECTCODE</TD><TD>Sum(REVENUES)</TD><TD>sum(COSTS)</TD><TD>Sum(REVENUES)</TD><TD>sum(COSTS)</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">profit/loss</FONT></TD><TD><FONT color="#FF0000">profit/loss</FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>3078</TD><TD>1597,2</TD><TD>1437,48</TD><TD>1000</TD><TD>900</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">159,72</FONT></TD><TD><FONT color="#FF0000">100</FONT></TD><TD><FONT color="#FF0000">597,2</FONT></TD><TD><FONT color="#FF0000">537,48</FONT></TD><TD><FONT color="#FF0000">59,72</FONT></TD></TR><TR><TD>3126</TD><TD>2395,8</TD><TD>2156,22</TD><TD>1100</TD><TD>990</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">239,58</FONT></TD><TD><FONT color="#FF0000">110</FONT></TD><TD><FONT color="#FF0000">1295,8</FONT></TD><TD><FONT color="#FF0000">1166,22</FONT></TD><TD><FONT color="#FF0000">129,58</FONT></TD></TR><TR><TD>3149</TD><TD>2635,38</TD><TD>2371,842</TD><TD>1210</TD><TD>1089</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">263,538</FONT></TD><TD><FONT color="#FF0000">121</FONT></TD><TD><FONT color="#FF0000">1425,38</FONT></TD><TD><FONT color="#FF0000">1282,842</FONT></TD><TD><FONT color="#FF0000">142,538</FONT></TD></TR><TR><TD>3169</TD><TD>0</TD><TD>0</TD><TD>1452</TD><TD>1306,8</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">0</FONT></TD><TD><FONT color="#FF0000">145,2</FONT></TD><TD><FONT color="#FF0000">-1452</FONT></TD><TD><FONT color="#FF0000">-1306,8</FONT></TD><TD><FONT color="#FF0000">-145,2</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>attached the qvw file</P><P>any suggestion? thank you in advance</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1617557#M734728 maxronny 2020-11-25T16:16:04Z Re: help on creating pivot table with formulas https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1617568#M734729 <P>see attached</P><P>Regards</P> Wed, 28 Aug 2019 11:14:52 GMT https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1617568#M734729 martinpohl 2019-08-28T11:14:52Z Re: help on creating pivot table with formulas https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1617572#M734730 <P>thank you very much for your reply.</P><P>can you tell me how can i get these other columns</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>revenues 2019vs2018</TD><TD>costs 2019vs2018</TD><TD>profit/loss 2019vs2018</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>597,2</TD><TD>537,48</TD><TD>59,72</TD></TR><TR><TD>1295,8</TD><TD>1166,22</TD><TD>129,58</TD></TR><TR><TD>1425,38</TD><TD>1282,842</TD><TD>142,538</TD></TR><TR><TD>-1452</TD><TD>-1306,8</TD><TD>-145,2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thank you very much for your support.</P> Wed, 28 Aug 2019 11:20:53 GMT https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1617572#M734730 maxronny 2019-08-28T11:20:53Z Re: help on creating pivot table with formulas https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1620559#M734731 <P>I found the solution.</P><P>DSUM in excel file can be written in qlik like this:</P><P><STRONG>=Sum({&lt;[DATE] = {'31/12/2018'}&gt;} [REVENUES])</STRONG></P> Thu, 05 Sep 2019 13:04:23 GMT https://community.qlik.com/t5/QlikView/help-on-creating-pivot-table-with-formulas/m-p/1620559#M734731 maxronny 2019-09-05T13:04:23Z