Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
piyush_s11
Contributor

Urgent Help Required to write a script function

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

1 Reply
Claudiu_Anghelescu
Contributor III

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.