topic Re: Returning Customers - dynamic period in QlikView

Returning Customers - dynamic

dana — Sat, 16 Nov 2024 17:56:22 GMT

Hi People,

I have a request to display returning customers as a dynamic KPI, meaning, for the previous 6 month of a selected date.

The user selects a product, and a returning customer would be a customer that bought one or more product after the first buying date of the selected product. I'm struggling with a Set Analysis expression to count the relevant customers.

I have managed to calculate the number of return dates:

Sum(aggr(Count({<Creation_Date = p({<Product_Group=, Creation_Date = {">$(=min(Creation_Date))"}>} )>}DISTINCT Creation_Date),Customer))

In order to count the relevant customers I added:

=Count({< Customer = {"Sum(aggr(Count({<Product_Group=, Creation_Date = p({<Creation_Date = {'>$(=min(Creation_Date))'}>})>}DISTINCT Creation_Date),Customer))>0"}>}DISTINCT Customer)

But the above doesn't work: the result is 0.

Can someone help me figure out why?

Attached are the model & data.

Thanks in advance!

Re: Returning Customers - dynamic period

Anil_Babu_Samineni — Wed, 21 Oct 2020 16:04:31 GMT

Can you share us the demonstrate QVW as well using attached source.

Sum({<DateField={">=$(AddMonths(Max(DateField), -6))<=$(=Max(DateField))"}>} Measure) // This will return last 6 months data

And then, Please explain what is the outcome you are expecting

Re: Returning Customers - dynamic period

dana — Wed, 21 Oct 2020 17:52:56 GMT

Hi Anil,

Here is an example:

When the user selected "Bottles", the customers that have bought any products after the first Bottles buying date are returning. I attached the model.

Thanks!

Re: Returning Customers - dynamic

Brett_Bleess — Wed, 04 Nov 2020 18:32:25 GMT

@Anil_Babu_Samineni Hey man, here is another post, sorry, it appears notifications are still not working correctly, if you have a minute and can check the follow-up post, much appreciated sir. Thanks as always!

Regards,
Brett

Re: Returning Customers - dynamic period

Anil_Babu_Samineni — Thu, 05 Nov 2020 17:06:56 GMT

Hi, Can you please tell us the outcome here after Bottles selection? and explain the logic behing for output?

Re: Returning Customers - dynamic period

dana — Fri, 06 Nov 2020 05:52:21 GMT

Hi,

I have rephrased the issue in a different thread and it was resolved:

https://community.qlik.com/t5/QlikView-Creating-Analytics/Set-Analysis-with-nested-AGGR/td-p/1754779

Thanks for your help!

Re: Returning Customers - dynamic

dana — Fri, 06 Nov 2020 05:53:16 GMT

I have rephrased the issue in a different thread and it was resolved:

https://community.qlik.com/t5/QlikView-Creating-Analytics/Set-Analysis-with-nested-AGGR/td-p/1754779

Re: Returning Customers - dynamic

Anil_Babu_Samineni — Sat, 07 Nov 2020 13:25:03 GMT

Glad to hear, Anyway you can mark your reply as answer to close this thread !