topic Accumulation for Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Accumulation-for-Pivot-Table/m-p/429878#M160251 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am doing&nbsp; the rangesum function to do the cummulative in Pivot Table. I want to stop the cummatlation if there is no value in the below quarters. </P><P></P><P>e,g, for 2013 there is no value after Q1 hence put a conidition and stoped the accumulation.&nbsp; </P><P></P><P>For 2012 there is no value in Q2 and Q3. but there is value for Q4, hence I want to repeat the values of Q1 in Q2 and Q3. </P><P></P><P>Please let me know if you need any more information. I have attached a sample QVW for your reference.</P><P><BR />Thanks,<BR />Sijo Joseph</P></BODY></HTML> Tue, 12 Feb 2013 16:25:08 GMT 2013-02-12T16:25:08Z Accumulation for Pivot Table https://community.qlik.com/t5/QlikView/Accumulation-for-Pivot-Table/m-p/429878#M160251 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am doing&nbsp; the rangesum function to do the cummulative in Pivot Table. I want to stop the cummatlation if there is no value in the below quarters. </P><P></P><P>e,g, for 2013 there is no value after Q1 hence put a conidition and stoped the accumulation.&nbsp; </P><P></P><P>For 2012 there is no value in Q2 and Q3. but there is value for Q4, hence I want to repeat the values of Q1 in Q2 and Q3. </P><P></P><P>Please let me know if you need any more information. I have attached a sample QVW for your reference.</P><P><BR />Thanks,<BR />Sijo Joseph</P></BODY></HTML> Tue, 12 Feb 2013 16:25:08 GMT https://community.qlik.com/t5/QlikView/Accumulation-for-Pivot-Table/m-p/429878#M160251 2013-02-12T16:25:08Z