topic Re: Dynamic Formula using Excel in QlikView

Dynamic Formula using Excel

renuka_sasikumar — Sat, 16 Nov 2024 05:15:48 GMT

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

Re: Dynamic Formula using Excel

techvarun — Wed, 14 Nov 2018 06:35:56 GMT

Explain the question and post the expected output.

Add a sample app if possible

Re: Dynamic Formula using Excel

vitaliichupryna — Wed, 14 Nov 2018 08:44:18 GMT

Hi Renuka,

You can create excel file with calculations :

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

Thanks,

Vitalii