topic Re: While Condition in QlikView https://community.qlik.com/t5/QlikView/While-Condition/m-p/688835#M1067399 <HTML><HEAD></HEAD><BODY><P>See this document: <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A> and perhaps this blog post: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/09/02/loops-in-the-script" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Loops in the Script</A></P></BODY></HTML> Tue, 02 Sep 2014 09:37:28 GMT Gysbert_Wassenaar 2014-09-02T09:37:28Z While Condition https://community.qlik.com/t5/QlikView/While-Condition/m-p/688834#M1067398 <HTML><HEAD></HEAD><BODY><P>int outstanding_value;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; while(outstanding_value&gt; Sales)</P><P>{</P><P>&nbsp;&nbsp;&nbsp;&nbsp; outstanding_value = outstanding_value - Sales</P><P>} break;</P><P></P><P>how can I develop this logic in qlikview kindly help</P><P></P><P>example:</P><P></P><P>let Outstanding_value = 1200000</P><P>Sales&nbsp;&nbsp;&nbsp;&nbsp; Apr&nbsp;&nbsp;&nbsp;&nbsp; May&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jun&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; July&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Aug</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 600000</P><P></P><P>if(Outstanding_value&gt; Sales(July)</P><P>1200000</P><P>-600000</P><P>-------------</P><P>600000 output = 'A'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; assume</P><P></P><P>now</P><P>if(A &gt; sales(jun), A- Sales(Jun))</P><P></P><P>it should compare until my outstanding value will be less than my Month sales.</P><P></P><P>Kindly help to buid this logic.</P><P></P><P>This logic is to calculate Daily sales outstanding.</P><P></P><P><BR /> </P></BODY></HTML> Tue, 02 Sep 2014 09:01:12 GMT https://community.qlik.com/t5/QlikView/While-Condition/m-p/688834#M1067398 abhaysingh 2014-09-02T09:01:12Z Re: While Condition https://community.qlik.com/t5/QlikView/While-Condition/m-p/688835#M1067399 <HTML><HEAD></HEAD><BODY><P>See this document: <A href="https://community.qlik.com/docs/DOC-3786">Generating Missing Data In QlikView</A> and perhaps this blog post: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/09/02/loops-in-the-script" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Loops in the Script</A></P></BODY></HTML> Tue, 02 Sep 2014 09:37:28 GMT https://community.qlik.com/t5/QlikView/While-Condition/m-p/688835#M1067399 Gysbert_Wassenaar 2014-09-02T09:37:28Z