Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

 

 

4 Replies
Highlighted
Partner
Partner

Use the addweeks function

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

etc

Highlighted
Contributor III
Contributor III

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

expression returns 0 value

Highlighted
Partner
Partner

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?

Highlighted
Contributor III
Contributor III