Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
my qvw
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
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?
Hi Sunny
i will make use of expression you given me to cmopute the table and chart.
Paul
Hi Tim
Do you install QLIK sense ? If yes I can send you QVF .
Paul
Sent from my iPhone