Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
samuel_lin
Contributor

Set Analysis with Variables

Hello all,

I have a table for transaction in Qlik with the following fields (simplified):

[CustomerID]

[Order Date]

....

here are the variables in load script:

SET minDate_1 = date(min([order date])-1);

SET l90d=date(min([order date])-90);

SET l180d=date(min([order date])-180);

Set l270d=date(min([order date])-270);

Set l365d=date(min([order date])-365);

I have a straight table with just one dimension: monthName([Order Date]),

and I am trying to measure, for example the # of customers, who have ordered within 90 days, within 180 days...


for example:


Jan 2016

Feb 2016

Mar 2016


I would like to know, for customers who purhcased in Jan 2016, how many had purchased 90 days before Jan 2016 (roughly Sep2015~Dec2015), and then 180days and so forth.


Any ideas? 


Tags (1)