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: 
paulyeo11
Master
Master

How to break the complex expression into 2 part ?

Hi All

I have below expression from sunny working fine . May i know how to break the below expression into 2 part ?

(RangeSum(Above(RangeSum

(Above(

Sum

(

{

<

year, month, aP={aP}

>

}

[Amount]*-1), 0, RowNo()))),

-

Sum(

{

<

aP={aP}>

}

TOTAL Aggr(Sum(

{

<

year, month, aP={aP}

>

}

[Amount]*-1), YearMonth

))))

So that i can make it as load script.

Paul

3 Replies
paulyeo11
Master
Master
Author

my qvw

jonathandienst
Partner - Champion III
Partner - Champion III

Above, Aggr() and set expressions do not work in the load script, so it is not a simple conversion. And its not clear how you want to "split" the expression. You also need to explain the context of the expression - if its in a table/chart, what are the dimensions, and how are they sorted, etc.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
paulyeo11
Master
Master
Author

Hi Jona

The reason I want to spilt is because I need to compute the Cash conversion cycle. I manage to get 2 items right but only 1 items I cannot get it correct. That AP account payable.

Are you able to give me some suggestion ?

Paul

Sent from my iPhone