While Condition

[abhaysingh]

int outstanding_value;

     while(outstanding_value> Sales)

{

     outstanding_value = outstanding_value - Sales

} break;

how can I develop this logic in qlikview kindly help

example:

let Outstanding_value = 1200000

Sales     Apr     May                         Jun                    July          Aug

                       300000                  400000           600000

if(Outstanding_value> Sales(July)

1200000

-600000

-------------

600000 output = 'A'           assume

now

if(A > sales(jun), A- Sales(Jun))

it should compare until my outstanding value will be less than my Month sales.

Kindly help to buid this logic.

This logic is to calculate Daily sales outstanding.

[Gysbert_Wassenaar]

See this document: Generating Missing Data In QlikView and perhaps this blog post: Loops in the Script