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