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

How to break the complex expression into 2 part ?

paulyeo11 — Wed, 27 Jul 2016 08:21:35 GMT

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

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

paulyeo11 — Wed, 27 Jul 2016 08:23:41 GMT

my qvw

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

jonathandienst — Wed, 27 Jul 2016 08:28:44 GMT

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.

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

paulyeo11 — Wed, 27 Jul 2016 09:21:55 GMT

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