date range in set analysis

[kristof_j]

Hi

I want to show an evolution of how many customers there are on a given date + x days.

I tried with set analysis but I can't get it right.

In my example I took 60 days but even better if it can be dynamic with a variable

update: in the line graph you should see 2 customers untill March

then 1 for 4 more days because of B,

then June 1st back 1 customer

...

[Anonymous]

did you check this?

Set Analysis Date Range | Qlik Community

QlikView App: Dates, Date Ranges and Set Analysis

[Anonymous]

use this Expression:

=count(DISTINCT {<Date={'>=$(=max(Date))<=$(=addmonths(Date,2))'}>} Customer)

addmonths will add you 60 or 61 days

if yopu select 1/7/2016 and add custome rto your dimensions you get

[kristof_j]

Can't get it right

I get 0 when I try :

count(DISTINCT {< Date = {">=$(=date(Date))<=$(=date(Date+60))"} >} Customer)

[kristof_j]

That does work when you select one date but not when I want to show an evolution like in a line graph

[sunny_talwar]

Not sure, but can you check if the attached file is what you want.

Best,

Sunny

[kristof_j]

Getting close ... this is what I want but I also want to show other metrics on the same graph that use Date and nog ReportDate.

Alternatively I can split the graphs but when a selections is made on Date, then I need to use triggers or something similar to select the same period on ReportDate.

[sunny_talwar]

To add another type of expression which is based off another calendar, you will need to use Canonical Date‌