I am working on a sales application and I need to know if QlikView can do the following:
1. Provide week over week % differences (ie - last week was 20% higher than the previous week) in the overall funnel and closure with the drill down upto single opportunity level.
Thanks for any insight into the capabilities of QlikView.
There are a couple of ways to do this, but without the data it is difficult to say which way to do it. However, if you try the following, you can get a picture of one way to do it:
1. Create a chart, e.g. a pivot table
2: Add a Dimension - Week Number
3. Add a first expression Sum(Number) - whichever number you want to analyze
4. Add a second expression Sum(Number) / Above(Sum(Number)) - 1. Format as percentage.
.png "Former Employee"){kind=icon}
