Time Comparison

saurabh_karlewar — Mon, 17 Feb 2014 10:56:16 GMT

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

Re: Time Comparison

hic — Mon, 17 Feb 2014 18:59:18 GMT

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

topic Time Comparison in QlikView

Time Comparison

Re: Time Comparison