Export table to Excel for each available field selection

mattiasbrandt — Wed, 07 Feb 2018 12:54:51 GMT

Hi,

I have a table where I have calulated income the last 12 months where the salesperson is the same as the account manager using this syntax:

Sum( {$<IsInvoiced={1},MonthYear={"<=$(=max(MonthYear)-1)>$(=max(MonthYear)-13)"},PersonSales={"$(=GetFieldSelections(PersonAccountManager))"}>} Income)

In a table like this:

AccountManager	Account	Income
Person 1	Customer 1	1 000 000
Person 1	Customer 2	500 000
Person 1	Customer 3	100 000

The issue is that I can only select one PersonAccountManger at time and now I need to export all of the account mangers, which is approx 100 and very timeconsuming.

Can the syntax be mended to only display the income where the Salesperson is equal to the account manager, couse then I can use Excel VBA to create new workbooks per accountmanager.

Or if one can, via VBA, export one table per account manager to excel directly from Qlik View?

The goal is to have on Excel-file with this tabel per account manager and created as easy as possible.

Any suggestions?

Best Regards Mattias

topic Export table to Excel for each available field selection in QlikView

Export table to Excel for each available field selection