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: 
renuka_sasikumar
Creator III
Creator III

Dynamic Formula using Excel

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

Labels (1)
2 Replies
techvarun
Specialist II
Specialist II

Explain the question and post the expected output.

 

Add a sample app if possible 

 

vitaliichupryna
Creator III
Creator III

Hi Renuka,

You can create excel file with calculations :

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

Thanks,

Vitalii