Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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
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?
Sorry. This is mistake. Post updated