Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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
Valued Contributor II

Re: How to break the complex expression into 2 part ?

my qvw

MVP
MVP

Re: How to break the complex expression into 2 part ?

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
Valued Contributor II

Re: How to break the complex expression into 2 part ?

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

Community Browser