topic Table with count distinct during last year for every date in App Development

Table with count distinct during last year for every date

frsvch — Mon, 12 Aug 2019 14:34:26 GMT

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

Date	Number of customers
08.03.2017	3456
…
10.02.2018	6590

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-variables/m-p/69732

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

Gysbert_Wassenaar — Mon, 12 Aug 2019 13:41:40 GMT

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?

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

frsvch — Mon, 12 Aug 2019 14:37:25 GMT

Sorry. This is mistake. Post updated