Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
chematos
Specialist II
Specialist II

Label disappear when export table from AccessPoint

Hi all,

I have a pivot table with a few expression, one label of these expressions is as follows:

='$(=only(Calendar.Quarter)) '& $(=only(Calendar.Year)) & ' vs ' & '$(=only(Calendar.Quarter)) ' & $(=only(Calendar.Year)-1) & ' Variance'

To export the table I have a macro that is working perfectly, running from Qlikview Desktop. When I export the table using this macro from Internet Explorer, using IE plugin, the label disappear from my Excel application and I don't know why. If this is working in Qlikview Desktop, why this is not working in the web browser? Is the macro trying to calculate the value of the label during the macro execution? Also, if I click in XL button or i export the table with right click, the label appears, only disappears when I export through the macro...


I hoped that the label would be exported as a text, already calculated. Any thoughts?

Appreciate any help.

Regards,

Jose

0 Replies