Urgent Help Required to write a script function

piyush_s11 — Sat, 16 Nov 2024 04:04:50 GMT

Hi,

I need help in writing a script function in load script.

I want to convert an expression : if(Continent=$(vPlantContinent), sum({<ObjectID={CHART1,CHART2,CHART3},Dept={Dept1}>}Actual)) into a script function.

in script editor, ABC Tab you will find sample function created.

For function vFHS_Table1_Actual I wanted to implement above mentioned formula.

Please find attached file for reference.

Thanks

Re: Urgent Help Required to write a script function

manoranjan_d — Fri, 22 Mar 2019 10:21:15 GMT

Please let us know whether fields involved in the same table or not.

To brg this formula in script function

try to use resident load the tabel with

Load

sum(actual)

from xx

where Continent=$(vPlantContinent) and ObjectID=CHART1 and ObjectID= CHART2 and ObjectID=CHART3 and Dept=Dept1

topic Re: Urgent Help Required to write a script function in QlikView

Urgent Help Required to write a script function

Re: Urgent Help Required to write a script function