Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
TerDah
Partner - Contributor
Partner - Contributor

How can I access "new" column in the Excel add-in?

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.

Labels (3)
1 Solution

Accepted Solutions
Frank_S
Support
Support

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...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies
Frank_S
Support
Support

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.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/excel-add-in-o...

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...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
TerDah
Partner - Contributor
Partner - Contributor
Author

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.

TerDah_2-1727901976161.png

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.

TerDah_3-1727902027199.png


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 %.

 
Frank_S
Support
Support

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...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!