Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Explain the question and post the expected output.
Add a sample app if possible
Hi Renuka,
You can create excel file with calculations :
http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/
Thanks,
Vitalii