Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
frsvch
Contributor
Contributor

Table with count distinct during last year for every date

Hi all!

I have 2 columns (date,  customer_id) and i need calculation table with count of distinct customer_id during last 12 month for every date.

For example

DateNumber of customers
08.03.20173456
 
10.02.20186590

 

where 3456 -number of unique customer_id between 08.03.2017 and 08.03.2016

or 6590 - number of unique customer_id between 10.02.2018 and 10.02.2017.

 

I used solution like this, but it only works with the date that i set in the filter 

https://community.qlik.com/t5/Qlik-Sense-App-Development/How-to-count-values-between-two-dates-varia...

2 Replies
Gysbert_Wassenaar

Can you explain the date intervals? I don't know of any definition of 12 months that matches the interval between 08.06.2016 and 08.03.2017. Why isn't the interval 08.06.2016 to 08.06.2017?


talk is cheap, supply exceeds demand
frsvch
Contributor
Contributor
Author

Sorry. This is mistake. Post updated