Hi All,
We are moving our data from an old database and reporting system to Qlik and are trying to replicate our old win loss report. We have moved the data from our old system into a new database that houses multiple "snap shots" of the full database appended to the end of each other with a "snapshot date" captured. Our old win loss report would compare 2 snapshots with each other to show a count of individual accounts in each of 4 Make categories for one snapshot in time vs another snapshot in time (I've attached an image of an example of our old report in hopes that it will help to illustrate what we're trying to accomplish). If an account had changed from one make to another make between those two snapshots in time, the report would indicate that x number of accounts moved from Make B to Make C for example. We've been able to get the count of accounts replicated in Qlik, but have not been able to replicate the indication of accounts moving from one make to another. Please let me know if you need any further clarification. Any help is much appreciated!!
