Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2014-06-23 06:01 AM

Excel Formulas not effecting when Data is exported

Hi
I require some help with a Basic Job. I?m importing data from a .cvs file to an excel file. I used tMap to JOIN in the Data.
I used an excel template (TimeSheet_Report_Test.xlsx) with some formulas in it. The Data exports to the excel just fine, but the formulas in the excel do not take effect when the data is exported to the excel file.
Hence the Formulated Columns to not change.
Does someone have a solution for refreshing the formulas in the column so they can take effect on the data?

I'm using File Delimited > tMap > tFileOutputExcel

Labels (2)
Labels
339 Views
0 Likes
10 Replies
Anonymous
Not applicable
‎2014-06-23 07:47 AM
Author

After executing the job, when you open your excel file, whether you see your formulas entered while creating template?
Whether the position of data insertion and formula available in the cell is conflicting?
As soon as you open the worksheet, formula's should take into the effect to evaluate the calculations.
Probably, your formulas are wiped off after writing data into the excel sheet... please confirm.
Thanks
Vaibhav
297 Views
0 Likes
Anonymous
Not applicable
‎2014-06-23 09:17 AM
Author

Hi Vaibhav
The Data is imported into the correct field. I just oped the excel and then double click on the affect all columns and then only the does the formula take effect on the field. The formulas are still present in the excel after executing the Export.
Could it have something to do with me checking the "Write excel2007 file format(xlsx)" checkbox.
If I don't check the checkbox then I'm not able to import the Data into the excel. I'm not sure why the formulas are not taking effect.
Let me know if you know what the problem could be.
297 Views
0 Likes
Anonymous
Not applicable
‎2014-06-23 09:23 AM
Author

Could it have something to do with me checking the "Write excel2007 file format(xlsx)" checkbox.
>>
This is required only when your output file is in .xlsx format what is the format (.xls/.xlsx) of your template?
Do you have onclick macro to apply formulas?
Vaibhav
297 Views
0 Likes
Anonymous
Not applicable
‎2014-06-23 09:48 AM
Author

The Template is .xlsx
I don't have a Marco to apply the formulas. The Formulas are just present in the Sheet.
I thought the Formulas will effect the Cell once the Data is imported.
297 Views
0 Likes
Anonymous
Not applicable
‎2014-06-23 10:01 AM
Author

If your template is .xlsx, then you have to enable that check box... and test again.
297 Views
0 Likes
Anonymous
Not applicable
‎2014-06-23 10:04 AM
Author

I have checked the xlsx box and ran the Job. Everything is importing fine but the Formulas are still not taking effect.
Have any idea?
297 Views
0 Likes
Anonymous
Not applicable
‎2014-06-23 10:19 AM
Author

The template is also in the .xlsx format.
297 Views
0 Likes
richie1985
Contributor
Contributor
‎2015-02-16 04:14 PM

i have the same problem, formula wont work 0683p000009MPcz.png
297 Views
0 Likes
Anonymous
Not applicable
‎2016-03-30 04:32 AM
Author

I have the same problem. 
But, if I click "Enable Editing" when I open the excel, the formulas will be refreshed.
However, it would be great if these could refresh without this.
297 Views
0 Likes