Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
piyush_s11
Creator
Creator

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
Specialist
Specialist

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.