Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone!
i would like to have a suggestion.
I have 2 tables created as follow, which are 2 different element in QV. The need is to extract the two table in excel and have a unique excel to be sent out to several stakeholder.
Currenlty i have to extract each table, and then merge the 2 extraction in one excel file. There's any way to extract just with one click the 2 tables? Maybe also using some other functionalities in qlik.
Thank you
Hi
You can write a macro to add these two tables to an excel and format accordingly.
Regards
Pratyush
A macro, in excel you mean ?
Use Ctrl+M, a module would open where you can write a VBScript in Qlikview itself.
Regards
Pratyush
Among other examples, this should work: Re: Macro to export multiple tables in to single excel
However, note that these macros will not work when you open the document via AccessPoint