Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See this document: Generating Missing Data In QlikView and perhaps this blog post: Loops in the Script