topic Re: How can I access "new" column in the Excel add-in? in Reporting Service & Alerting

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

TerDah — Wed, 02 Oct 2024 07:11:04 GMT

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.

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

Frank_S — Wed, 02 Oct 2024 14:34:44 GMT

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

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

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

TerDah — Wed, 02 Oct 2024 20:48:56 GMT

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

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

Frank_S — Wed, 02 Oct 2024 22:03:57 GMT

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

topic Re: How can I access &quot;new&quot; column in the Excel add-in? in Reporting Service & Alerting

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

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

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

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

topic Re: How can I access "new" column in the Excel add-in? in Reporting Service & Alerting