topic Re: Automatic mail triggering in qlikview in QlikView

Automatic mail triggering in qlikview

Thu, 03 Apr 2014 06:42:01 GMT

Hi ,

Is it possible in qlikview to extract values from different sheets in dashboard and copy the same in a excel file and automatically trigger a mail with the excel attached.

Thanks in advance.

Re: Automatic mail triggering in qlikview

its_anandrjs — Thu, 03 Apr 2014 06:46:57 GMT

Yes you have to use macros for this read different object data and make single object and trigger a macro to send this excel.

Hope this helps

Re: Automatic mail triggering in qlikview

Thu, 03 Apr 2014 06:49:48 GMT

Hi Anand,

Thanks for your quick response.

can u please explain me in detail. i am new to qlikview.

Thanks.

Re: Automatic mail triggering in qlikview

its_anandrjs — Thu, 03 Apr 2014 07:02:28 GMT

Suppose you have three objects like straight tables read a data from this tables by macro and maintain another sheet with this macros and by macro export to excel export this excel files. and in email macro use this macro object to send to different user please refer the reference manual or community you get information about this and it is lengthy process and need time to test this macros or refer a API guide also.

Hop this helps

Re: Automatic mail triggering in qlikview

gradiske — Fri, 27 Feb 2015 13:30:42 GMT

I've made one a few years ago, to take all the objects in the table, including objects inside containers, all in one xls file and prompting a message to put the email address to send the file.

But, after some months everything was ruined due to the fact that macros won't work on Ajax anymore(i don't about qvplugin these days). At that time, our costumers we're only using Ajax basically because of mobile only usage.

I don't know where's this piece of code is right now but i'll try to find it. Maybe it's useful for someone in the community.