Discussion board where members can get started with Qlik Sense.
Hello! I am trying to create a field/column that will label a customer as "Existing customer" if the number of sales is greater than 1, and "New Customer" if the # is <=1. I created a function listed below.
if(Count([Sale Amount]>1, 'Existing Customer', if(Count([Sale Amount]<=1, 'New Customer'))))
But it says "Nested aggregation not allowed". What is the right way to create this?
I also tried to add field in data manager, but there is no count or sum options. Either way is fine!
Go to Solution.
if(Count([Sale Amount])>1, 'Existing Customer', 'New Customer')
View solution in original post