Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Giselle100
New Contributor II

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

 

 

4 Replies
OmarBenSalem
Esteemed Contributor II

Re: Promotions Set Analysis

Use the addweeks function

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

etc

Giselle100
New Contributor II

Re: Promotions Set Analysis

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

expression returns 0 value

OmarBenSalem
Esteemed Contributor II

Re: Promotions Set Analysis

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
New Contributor II

Re: Promotions Set Analysis