Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a report in the Excel add-in that works fine.
Now, I have added a new column to the table in Qlik that the Excel add-in is connected to. How can I access this column in the Excel add-in? I can't find it even when trying to create a new report.
I have tried switching the source app back and forth and refreshing everywhere possible, but it doesn't seem to work.
If you are using a 3rd party table (not a native qlik table, chart or visualization bundle object), that 'might' be the reason.
If this is the case, try using a native Qlik table object and try again. It should work normally with a native Qlik table.
Then report the issue to the vendor of your 3rd party visualization (again, assuming that you are using a 3rd party table extension object)
Limitations for tabular reporting
- Third-party extensions are not supported.
Kind regards...
Check out this video. It explains how to work with your MS excel report template after connecting to the sense app via the add-on feature.
https://share.vidyard.com/watch/tHdRWQAMTu5JC3hMTTUgcP?autoplay=2&second=159.47
or watch it directly in this link at 2m37secs.
To work with individual fields, you need to choose the individual columns option.
If your source chart is pivot table, you need to convert that to straight table (make a copy, convert the copy) and access the new straight table in your report template (don't forget to give the chart a title name so it can be easily recognized).
But before you can do this you must ensure you are connected to your app from the adding, choose the right chart/table and proceed from there.
If you are trying to do something else please provide:
1. Steps to reproduce
2. Expected results
3. Actual results.
4. Images that demonstrate the steps and or your specific requirement.
Kind regards...
I have been working with this for a while, and it’s working fine, but when I added a new data point in the Qlik Cloud app, it doesn’t show up in the Excel add-in.
This is from Qlik cloud app.
Here you can see the columns I’m using, sorry that they are in Norwegian
The one I have marked in red is new, meaning it was just added.
When I go into the Excel add-in, it doesn’t show up.
I’ve tried everything—changed the source app to another and back again, refreshed, and even created a new table—but nothing seems to bring up the data point called “Rabatt %.
If you are using a 3rd party table (not a native qlik table, chart or visualization bundle object), that 'might' be the reason.
If this is the case, try using a native Qlik table object and try again. It should work normally with a native Qlik table.
Then report the issue to the vendor of your 3rd party visualization (again, assuming that you are using a 3rd party table extension object)
Limitations for tabular reporting
- Third-party extensions are not supported.
Kind regards...