Data comparaison from a starting Date

Wed, 17 Feb 2010 09:56:17 GMT

Dear community

As I'm not very comfortable with the Set Analysis, I call the community for Help on this case.

I have a big table with 3 fields :
- Store
- Monthname ( Jan08, Feb08 , ...., Jan10)
- Revenu

I have also a lookup table with 2 fields :
- Store
- StartMonth which is a Monthname where a test begin
- Dummy = 1

This Table is a subset of Store (not all store are testing)

I want to display in chart (straigt-table) some various calculation by store or by StartMonth :

- Cumulate revenu for the next 3 month after StartMonth
If StartMonth = Jan09 , i need the cumulation of Feb09, Mar09 & Apr09

- Cumulate revenu for the last 3 month before StartMonth
If StartMonth = Jan09 , i need the cumulation of Oct08, Nov08 & Dec09

- Cumulate revenu for the last 3 month after StartMonth but for previous year
If StartMonth = Jan09 , i need the cumulation of Feb08, Mar08 & Apr08

I need also to compare this figures to another subset of store for example the not testing store (Dummy = 1).

Many thanks for your Help

Jean-Jacques

Data comparaison from a starting Date

Wed, 17 Feb 2010 20:29:47 GMT

I re post Help !

Jean-Jacques

Data comparaison from a starting Date

Wed, 17 Feb 2010 20:40:18 GMT

Is there any chance that a date is available in the same table?

Data comparaison from a starting Date

Wed, 17 Feb 2010 21:23:04 GMT

Yes it's possible.

Data comparaison from a starting Date

Wed, 17 Feb 2010 21:40:35 GMT

Dates can get ugly and any sample I provide is probably not going to be accurate because of formatting issue. Do you have a sample?

topic Data comparaison from a starting Date in QlikView

Data comparaison from a starting Date

Data comparaison from a starting Date

Data comparaison from a starting Date

Data comparaison from a starting Date

Data comparaison from a starting Date