Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

frsvch
New 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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Table with count distinct during last year for every date

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
New Contributor

Re: Table with count distinct during last year for every date

Sorry. This is mistake. Post updated