topic How to convert expression into load script ? in QlikView

How to convert expression into load script ?

paulyeo11 — Thu, 21 Apr 2016 04:00:25 GMT

Hi All

My Table 1 Expression working fine :-

RangeSum(

Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),

-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))

Now i like to convert this into load script :-

RangeSum(

Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),

-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth))) as STK

I get error msg :-

Error in expression:

ABOVE is not a valid function

left keep (GL_TABLE)

Paul

Re: How to convert expression into load script ?

paulyeo11 — Thu, 21 Apr 2016 04:01:29 GMT

my qvw

Re: How to convert expression into load script ?

zhadrakas — Thu, 21 Apr 2016 06:27:15 GMT

Hi Paul,

i can't open your qvw cause of Personal Edition.

In Load Script you can't use above(), Aggr() and Set Analysis.

you need to Aggregate the data in script like

SELECT *

FROM XX

WHERE GL_CODE = 50010

GROUP BY YEAR, MONTH

Re: How to convert expression into load script ?

sunny_talwar — Thu, 21 Apr 2016 08:40:07 GMT

It would be difficult to suggest a way to convert the expression into script without having the ability to reload. It is a complex expression and would require a lot of trial and error. Why do you want to take the calculation into the script?

Re: How to convert expression into load script ?

paulyeo11 — Thu, 21 Apr 2016 09:04:13 GMT

Hi Sunny

i will make use of expression you given me to cmopute the table and chart.

Paul

Re: How to convert expression into load script ?

paulyeo11 — Thu, 21 Apr 2016 21:09:07 GMT

Hi Tim

Do you install QLIK sense ? If yes I can send you QVF .

Paul

Sent from my iPhone