Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi Anand,
Thanks for your quick response.
can u please explain me in detail. i am new to qlikview.
Thanks.
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
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.