I am New to Qlik Sense, and I have a problem with Count of Lost/loyal/new customers.
I read several post but I did not find the right solution for QlikSense.
I have 3 information:
1 Customer name
I need to understand how many customer become lost in 2016 keeping in mind that for me lost customers are whose did not buy since 2013. People who bought in 2014 or 2015 but no in 2016 for me are “sleepy”. I would like to have the total numer.
For the moment, the only formula that helps me is the followig: