Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Giselle100
Contributor III
Contributor III

Promotions Set Analysis

DATA

Promo ID No = 2592

Promo Start Date = 17/01/2019

Sale Units as a measure.

 

Using set analysis, how do i get the sales units for the following:

1. 1 week before promo start date

2. 2 weeks before promo start date

3. promo start week

4. 1 week after promo start week

5. 2 weeks after promo start week

6. 3 weeks after promo start week

 

 

Labels (4)
4 Replies
OmarBenSalem

Use the addweeks function

1) sum({<StartDate={"$(=addweeks(max(StartDate),-1)})">}Sales)

etc

Giselle100
Contributor III
Contributor III
Author

sum({<[Promo Start Date]={"$(=addweeks(max([Promo Start Date]),-1))"}>}[Sale Units])

expression returns 0 value

OmarBenSalem

can u please create a table:

as dimension :

Promo Start Date

as measures:

sum(SalesUnits)

and the expression u've just shared and attach the outcome image?

Giselle100
Contributor III
Contributor III
Author