Dynamic Formula using Excel

[renuka_sasikumar]

Hi,

I have a excel which gives me more than 100 measures to calculate in back end. Is there a way for using the Excel in QlikView to derived the calculated field in the Script level or by anyway. Instead of doing calculation manually. Because in future there maybe a chance of chaining the logic, so it will become difficult in manual.

Attached the excel format.

Report Head Sl No Formula/VV filter
ABC Y01 Y05+Y03
DEF Y02 VV789
IJK Y03 VV011 Record type =F
LMN Y04 VV072 record type =F , Sales document type = ZADL,ZADSto ZAPO
QRS Y05 VV001
XYZ Y06 (Y04-Y02)+Y05

Regards,

Renuka S

[techvarun]

Explain the question and post the expected output.

Add a sample app if possible 

[vitaliichupryna]

Hi Renuka,

You can create excel file with calculations :

http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/

Thanks,

Vitalii