Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data comparaison from a starting Date


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


4 Replies
Not applicable
Author

I re post Help !

">

Jean-Jacques

Not applicable
Author

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

Not applicable
Author

Yes it's possible.

JJ

Not applicable
Author

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?