Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

While Condition

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.


1 Reply
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand