Hi,
I am doing a report on an Account Acquisition Campaign for my company. The Campaign consists if 12 "sub-Campaigns", which I want to report on separately and globally.
I have a sheet showing applications (approvals, declines, activation of approved accounts, etc.) per day.
I also have a sheet showing performance of these approved accounts (purchases, turnover, etc.) per day.
Currently it shows this per day, but only for the global campaign - I then have charts which pulls data from these sheets. I also have a main "summary" sheet (which is probably the only thing people look at, which shows the current situation (campaign start date, latest date, total approvals, activations, etc.), which for the most part also pulls data from the daily sheets, by loooking at the max value or sum of certain fields.
I pull the daily data from QlikView (so I just copy and paste to excel and everything updates itself).
My problem is that I want to somehow report on the 12 different campaigns without it looking messy. In QlikView I can add a dimension to my tables, so that for every day it shows the separate 12 campaigns (so each day will have 12 lines with all the different fields and people can filter on campaign name). This works nice for the summary sheet, because I can then globally show e.g. the approvals like this: =SUM('Application Stats by day'!E:E)
and for the different campaigns I can each have: =SUMIFS('Application Stats by day'!E:E,'Application Stats by day'!B:B,"=ACK SA: LB NEW. JUNE 2012")
My question is if I can do the same with charts - Can I have a chart pulling data with the date in Column A and the Approvals in Columns E, but only using the rows where Column B is equal to teh campaign name (e.g. ACK SA: LB NEW. JUNE 2012), and then shows the approvals per day for that one campaign?
I doubt it is possible but any ideas would be great. Sorry for the long post!
Gerhard
I am doing a report on an Account Acquisition Campaign for my company. The Campaign consists if 12 "sub-Campaigns", which I want to report on separately and globally.
I have a sheet showing applications (approvals, declines, activation of approved accounts, etc.) per day.
I also have a sheet showing performance of these approved accounts (purchases, turnover, etc.) per day.
Currently it shows this per day, but only for the global campaign - I then have charts which pulls data from these sheets. I also have a main "summary" sheet (which is probably the only thing people look at, which shows the current situation (campaign start date, latest date, total approvals, activations, etc.), which for the most part also pulls data from the daily sheets, by loooking at the max value or sum of certain fields.
I pull the daily data from QlikView (so I just copy and paste to excel and everything updates itself).
My problem is that I want to somehow report on the 12 different campaigns without it looking messy. In QlikView I can add a dimension to my tables, so that for every day it shows the separate 12 campaigns (so each day will have 12 lines with all the different fields and people can filter on campaign name). This works nice for the summary sheet, because I can then globally show e.g. the approvals like this: =SUM('Application Stats by day'!E:E)
and for the different campaigns I can each have: =SUMIFS('Application Stats by day'!E:E,'Application Stats by day'!B:B,"=ACK SA: LB NEW. JUNE 2012")
My question is if I can do the same with charts - Can I have a chart pulling data with the date in Column A and the Approvals in Columns E, but only using the rows where Column B is equal to teh campaign name (e.g. ACK SA: LB NEW. JUNE 2012), and then shows the approvals per day for that one campaign?
I doubt it is possible but any ideas would be great. Sorry for the long post!
Gerhard