topic Re: qlikview rollup in QlikView https://community.qlik.com/t5/QlikView/qlikview-rollup/m-p/1535393#M440776 <P>Please see the attached file for the code:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rollup.PNG" style="width: 715px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4561i1D429602645CD9B1/image-size/large?v=v2&amp;px=999" role="button" title="Rollup.PNG" alt="Rollup.PNG" /></span></P> Fri, 25 Jan 2019 19:09:55 GMT trdandamudi 2019-01-25T19:09:55Z qlikview rollup https://community.qlik.com/t5/QlikView/qlikview-rollup/m-p/1534728#M440775 <P>Here is the data .</P><TABLE><TBODY><TR><TD><P>center code</P></TD><TD><P>cedent cd</P></TD><TD><P>cedent name</P></TD><TD><P>geo</P></TD><TD><P>cont #</P></TD><TD><P>Amt1</P></TD><TD><P>Amt2</P></TD><TD><P>Am3</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2011</P></TD><TD><P>0</P></TD><TD><P>-524</P></TD><TD><P>300</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2012</P></TD><TD><P>12</P></TD><TD><P>56</P></TD><TD><P>-467</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2013</P></TD><TD><P>0</P></TD><TD><P>0</P></TD><TD><P>534</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2014</P></TD><TD><P>6</P></TD><TD><P>0</P></TD><TD><P>-234</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2015</P></TD><TD><P>1</P></TD><TD><P>4</P></TD><TD><P>23</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2016</P></TD><TD><P>0</P></TD><TD><P>0</P></TD><TD><P>34</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2017</P></TD><TD><P>2</P></TD><TD><P>0</P></TD><TD><P>-45</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>X345-2018</P></TD><TD><P>0</P></TD><TD><P>4</P></TD><TD><P>23</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And I need to show as mentioned below.</P><TABLE><TBODY><TR><TD><P>center code</P></TD><TD><P>cedent cd</P></TD><TD><P>cedent name</P></TD><TD><P>geo</P></TD><TD><P>Amt1</P></TD><TD><P>Amt2</P></TD><TD><P>Am3</P></TD></TR><TR><TD><P>X</P></TD><TD><P>123</P></TD><TD><P>DFGH</P></TD><TD><P>CENTRAL</P></TD><TD><P>21</P></TD><TD><P>-460</P></TD><TD><P>-400</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Data should roll up to cedent level but AMT1,AMT2, AMT3 should be displayed values only when AMT1&lt;&gt;0 OR AMT2&lt;&gt;0</P><P>&nbsp;How to achieve this using set analysis? please provide pointers.</P> Thu, 24 Jan 2019 19:00:32 GMT https://community.qlik.com/t5/QlikView/qlikview-rollup/m-p/1534728#M440775 laxmiprasanna 2019-01-24T19:00:32Z Re: qlikview rollup https://community.qlik.com/t5/QlikView/qlikview-rollup/m-p/1535393#M440776 <P>Please see the attached file for the code:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rollup.PNG" style="width: 715px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4561i1D429602645CD9B1/image-size/large?v=v2&amp;px=999" role="button" title="Rollup.PNG" alt="Rollup.PNG" /></span></P> Fri, 25 Jan 2019 19:09:55 GMT https://community.qlik.com/t5/QlikView/qlikview-rollup/m-p/1535393#M440776 trdandamudi 2019-01-25T19:09:55Z