Download Qlikview Report Automaticly

[Scorpioflz]

Hello 

We have a user with following background:

1.Here is a report managed by global HQ and the user of curse has the access to this report, she can visit the report on web view and everyday download it(make some selection then send to excel) for further usage;

2.She wants to make this job automatically,  but HQ IT doesn't support(for many reason), so she asked me if we have some solution that can "read" the data directly through some API or other interface so that  we can create an VBA/VBS tools for her to get the data everyday

So is there any solution like that? use some interface or coding tools to access the qlikview and download the data?

Felix

[mfchmielowski]

Hi.

There's an application named Qlik NPrinting designed to provide this kind of functions (open qlik app, make selections, send result by mail). Hope that this is not a "IT doens't support" solution 😉

[Lech_Miszkiewicz]

Totally agree - NPrinting is a tool to go for solutions like that! 

It may however seem expensive given that it requires separate server, license,  configuration and skill to set it up and use it. I know for the fact how often people underestimate sills required to properly build nprinting solution and fall under trap "I can do it - it is just 'drag&drop' tool" which is 1 % of the truth. Another 99% is to know document requirements, good practices, environmnet requirements etc... Long story short - NPrinting is exactly the tool you need, but it requires someone with the skill to set it up. It normally would not take long to someone experienced (1 day of work to fullly configure it).

Now there are some hacks you can do with Qlik View document itself if you really need to save money and want to take things in your own hands.. You could just write macro: samples below:

https://community.qlik.com/t5/QlikView-App-Dev/Script-for-Exporting-and-Sending-email/td-p/271970

especially this: -->

https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-documents/2303/4/QlikView%20Ex...

 hope this helps