topic Re: Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution in QlikView https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773693#M1027349 <HTML><HEAD></HEAD><BODY><P>Can you explain what you expect? In a cumulative sum a value 0 does not change the cumulative value. That's not skipping the value, but simple adding 0.</P></BODY></HTML> Tue, 10 Mar 2015 10:02:01 GMT Gysbert_Wassenaar 2015-03-10T10:02:01Z Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773692#M1027348 <HTML><HEAD></HEAD><BODY><P>Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution</P></BODY></HTML> Tue, 10 Mar 2015 09:56:23 GMT https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773692#M1027348 2015-03-10T09:56:23Z Re: Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773693#M1027349 <HTML><HEAD></HEAD><BODY><P>Can you explain what you expect? In a cumulative sum a value 0 does not change the cumulative value. That's not skipping the value, but simple adding 0.</P></BODY></HTML> Tue, 10 Mar 2015 10:02:01 GMT https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773693#M1027349 Gysbert_Wassenaar 2015-03-10T10:02:01Z Re: Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773694#M1027350 <HTML><HEAD></HEAD><BODY><P>ya, it is not adding 0. it is adding just next value to it and showing in cumulative field. </P><P>Logic:</P><P></P><P>if( RowNo()&gt;1,if((month([Date_LD]) =month(Previous([Date_LD]))),([Sales_LD] + Peek([Cum Sales])),[Sales_LD]),[Sales_LD]) As [Cum Sales];</P></BODY></HTML> Tue, 10 Mar 2015 10:18:36 GMT https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773694#M1027350 2015-03-10T10:18:36Z Re: Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773695#M1027352 <HTML><HEAD></HEAD><BODY><P>You mean the Suppress Zero Values option is enabled? Try disabling it on the Presentation tab.</P></BODY></HTML> Tue, 10 Mar 2015 10:26:04 GMT https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773695#M1027352 Gysbert_Wassenaar 2015-03-10T10:26:04Z Re: Hi all ! while doing cummulative sum it is getting added all values, but skiping 0 value and adding the immediate nxt value. Plz suggest solution https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773696#M1027355 <HTML><HEAD></HEAD><BODY><P>Plz chk it,</P><P><IMG alt="Legdersum.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80339_Legdersum.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 10 Mar 2015 10:33:01 GMT https://community.qlik.com/t5/QlikView/Hi-all-while-doing-cummulative-sum-it-is-getting-added-all/m-p/773696#M1027355 2015-03-10T10:33:01Z