Difference between Makro Export and normal Qlikview Export to Excel

[phil-ebm]

Hello @All

In my report I export a table with a macro into a excel-template.

This table should have a "special" look and i create this look with a value list. This is working fine.

Now the problem:

When I select in a field "Fertigungsjahr" (Production Year) Values suddenly in the excel-export with the macro the lowest year appears behind the months from the value list.

When I do a normal excel-export with the "Send to Excel" the years won't appear.

The Selection does not affect the KPIs. My only Problem is, that suddenly the Year appears and I don't why because I do not change the Title by Selection. The Titles are always the same without year.

Can someone help me?

Can someone explain why I see the years with the macro and can't see the years by normal export?

Regards & Thanks

Phil

[m_woolf]

Since you provided only a screenshot, this is just a guess.

This could be a formatting issue in Excel. Click the cell for Jan and look at the formula bar to see the exact contents of the cell.

Do the same for the normal export. If the cell values are the same, it is a formatting issue.