Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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
manoranjan_d
Specialist
Specialist

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