Time Comparison

[saurabh_karlewar]

Hello --

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.

Saurabh

[hic]

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.

HIC