topic Re: date range in set analysis in QlikView

date range in set analysis

kristof_j — Mon, 29 Aug 2016 13:16:03 GMT

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

...

Re: date range in set analysis

Anonymous — Mon, 29 Aug 2016 13:19:14 GMT

did you check this?

Set Analysis Date Range | Qlik Community

QlikView App: Dates, Date Ranges and Set Analysis

Re: date range in set analysis

Anonymous — Mon, 29 Aug 2016 13:25:29 GMT

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

Re: date range in set analysis

kristof_j — Mon, 29 Aug 2016 13:27:08 GMT

Can't get it right

I get 0 when I try :

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

Re: date range in set analysis

kristof_j — Mon, 29 Aug 2016 13:29:14 GMT

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

Re: date range in set analysis

sunny_talwar — Mon, 29 Aug 2016 18:58:48 GMT

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

Best,

Sunny

Re: date range in set analysis

kristof_j — Tue, 30 Aug 2016 06:54:08 GMT

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.

Re: date range in set analysis

sunny_talwar — Tue, 30 Aug 2016 10:58:04 GMT

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