Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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.