idea Re: Allow data download from the Direct Query chart in Suggest an Idea

Allow data download from the Direct Query chart

motanaka — Mon, 23 Jan 2023 01:44:58 GMT

For data sources that are not Direct query, I can download the data from the table chart into Excel.

However, when using Direct Query to connect to Snowflake and create a table chart, the data download menu does not appear. The ability to download data to Excel is also required when using Direct Query.

Re: Allow data download from the Direct Query chart

Sreekanth_potu — Thu, 09 Mar 2023 18:57:20 GMT

We are trying to pull the data to excel to satisfy the live office use cases, the approach we are trying to do that is Snowflake --> Qlik (Direct Query)--> Analytics Gate (Excel Plugin) The problem we ran with this approach is while loading the data from Qlik (Direct Query) --> Analytics Gate (Excel Plugin) the data is limited to 1000 records (Note : This is happening only to direct query). IS there any way to remove Limit on the size of data

Re: Allow data download from the Direct Query chart - Status changed to: Open - Collecting Feedback

Ian_Crosland — Sat, 11 Mar 2023 10:05:53 GMT

Re: Allow data download from the Direct Query chart

Ian_Crosland — Sat, 11 Mar 2023 11:50:16 GMT

In regards to the 1000 record question, we added a new variable end of Jan which can be included in the script:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DirectQuery/internal-variables-direct-query.htm

this allow the 1000 row limit to be configured higher to enable more rows to be rendered in supported charts (with paging) within Qlik Sense so it will need to be validated if this will pass through your Analytics Gate plugin.

As an FYI you can subscribe to a news feed to get the latest on all new features here:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/saas-change-log.htm

Thanks

Ian

Re: Allow data download from the Direct Query chart

Sreekanth_potu — Wed, 15 Mar 2023 16:47:10 GMT

Hi @Ian_Crosland ,

we tried using the Variable but still it's not supporting, we tried few ways which are below

Re: Allow data download from the Direct Query chart

motanaka — Fri, 17 Mar 2023 05:20:32 GMT

Hi Ian,

Thank you for update.
I would like the ability to download data to Excel without having to use Analytics Gate.
Direct Query charts do not show the Export menu when right-clicked.

Thanks

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Mon, 18 Sep 2023 16:53:23 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Allow data download from the Direct Query chart - Status changed to: Closed - Archived

Ideation — Mon, 18 Sep 2023 16:53:25 GMT