Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Automatic mail triggering in qlikview

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.

4 Replies
its_anandrjs
Champion III
Champion III

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

Not applicable
Author

Hi Anand,

Thanks for your quick response.

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

Thanks.

its_anandrjs
Champion III
Champion III

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

gradiske
Contributor III
Contributor III

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.