This tutorial illustrates how to find customers who bought during the previous year but didn't during the current year.
Attention: this report is based on a specific QlikView chart. If you change the chart the report cloud not work any more.
Create a New Customer Table Chart
- Right-click in the QlikView Sheet
- Select New Sheet Object
- Select Chart
Select the Chart Type
- Enter Customers who didn't Buy as Window Title
- Click on the Straight Table icon
- Click on Next in the bottom-right side of the windows
Add the Customer Field
- Select Customer from the list
- Click on Add
- Click on Next
Set the Expression
Enter the expression int the code field
if( sum( {$<Year = {$(vCurrentYear)}>} Sales )=0 and sum( {$<Year = {$(vLastYear)}>} Sales )>0, 'Check' )
Click OK
Set the Field Name
- Enter Status as Label
- Select No Totals in the Total Mode box
- Click on Next
Save the QlikView Document
Start New Excel Report Template
After adding CH340 - Customers who didn't Buy:
- Drag the field nodes to be used into the template.
Result
In the result you can see all the customers that did buy during the previous year bud didn't during the current year