topic Re: Send to Excel Export....! in QlikView

Send to Excel Export....!

infosense_devel — Wed, 26 Apr 2017 09:12:08 GMT

Hello,

I want to restrict user to excel export for specific object on QVW to get export on Access point of Qlikview.

Don't want to disable functionality through out the QVW only on specific object, Suppose on one sheet I have 5 object 2 of them have access to excel export and other 3 don't.

I have tried,

disabling at QMC based on user name:

Also in QVW:

But this will in effect with all document all object.

but my requirement is to restrict based on object.

Thanks in Advance.

Re: Send to Excel Export....!

dsharmaqv — Wed, 26 Apr 2017 12:27:15 GMT

As per my knowledge its not possible for single object.

Re: Send to Excel Export....!

souma2020 — Fri, 08 Dec 2017 07:41:20 GMT

Hello,

May be it's not the right place to ask this question but i really need your help please.

I have a problem with sending a table to excel, the file in question is 23MB that I suppose is a normal size, but it takes more than 7 minutes to be downloaded, plus I've another extract on another tab of my application that is 19MB and that loads in less than 3 minutes!

I can not understand the root cause and it's starting to be annoying

can someone help me please?

& Thanks in advance.

Re: Send to Excel Export....!

neha_shirsath — Fri, 08 Dec 2017 12:01:55 GMT

I'm not getting what exactly you want is it like-

If you have 5 object on one sheet you want to give export to excel property to only 2 object not to rest 3.

Re: Send to Excel Export....!

Colin-Albert — Fri, 08 Dec 2017 13:54:52 GMT

Hi Somaya.

One option may be to add a calculation condition to the chart.
This will not prevent users from exporting it, but you can set the calculation condition so that the chart is not displayed until the users have filtered the data until fewer than N rows are selected.
This will stop the users from exporting massive data sets as if the cahrt is not displayed, it cannot be exported.

My first question is why are the users exporting the data - I take this as a sign that the Qlik app is not displaying the data the users wish to see. Perhaps you need to reveiw the users' requirements and what they are doing in Excel, and then update your Qlik app to provide this directly in Qlik.

Re: Send to Excel Export....!

souma2020 — Fri, 08 Dec 2017 16:17:55 GMT

Hi neha,

& thnx for ur answer.

actualy i've many tabs in my QV application (each tab show different results).

- So in the first tab (détails): when i do send to excel, the file is loaded in 3 minutes and its size is about 19Mo.

- But on the second tab (Syntése analyse): when i do send to excel, the file is loaded in more than 7 minutes and its size is about 23Mo.

And this is annoying to wait 7 and 8 minutes just to have the file!

so here i've files with the same size and they takes differents times to be loaded, and this is the problem for the end users.

Re: Send to Excel Export....!

souma2020 — Fri, 08 Dec 2017 16:18:52 GMT

Hi Colin,

as i explained to neha,

i've many tabs in my QV application (each tab show different results).

- So in the first tab (détails): when i do send to excel, the file is loaded in 3 minutes and its size is about 19Mo.

- But on the second tab (Syntése analyse): when i do send to excel, the file is loaded in more than 7 minutes and its size is about 23Mo.

And this is annoying to wait 7 and 8 minutes just to have the file!

so here i've files with the same size and they takes differents times to be loaded, and this is the problem for the end users.