Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today

Urgent Help Required to write a script function


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.


1 Reply
Valued Contributor

Re: Urgent Help Required to write a script function

if(Continent=$(vPlantContinent) and Match (ObjectID, ‘CHART1’, ‘CHART2’, ‘CHART3’) and Dept=‘Dept1’, sum(Actual)) as YourNewField
To help community find solutions, please don't forget to mark as correct.