QlikSense: Customers who have been Active previously but are not purchasing lately.

[Anonymous]

Hi All,

Similar to previous Product problem, now I'm stuck in Customer problem. Both seems same to me. Please help me finding the solution to it.

Question: Customers who have been Active previously but are not purchasing lately.

Attached herewith is the QVW for the same.

P.S. I won't be able to open the QVW as I don't have license.

Please post the solution as code or pics.

stalwar1‌

Thanks in advance.

[sunny_talwar]

What is the expected output here? I mean is this needed to be based on the same logic where a customer is present in first two years, but not present in the next 2?

[Anonymous]

What should we consider? OrderDate, OrderYear or OrderYearMonth. Not mentioned clearly so posted thought u wud know and help me understand the Question?

[sunny_talwar · Accepted solution]

All your questions are good questions which you should be asking your users instead of asking me. They have to dictate what they want...