Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

macdonaldm
New Contributor

workaround for nested aggregation

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!

1 Solution

Accepted Solutions
Highlighted
Channa
Valued Contributor III

Re: workaround for nested aggregation

if(Count([Sale Amount])>1, 'Existing Customer', 'New Customer')

try

Channa

View solution in original post

2 Replies
Highlighted
Channa
Valued Contributor III

Re: workaround for nested aggregation

if(Count([Sale Amount])>1, 'Existing Customer', 'New Customer')

try

Channa

View solution in original post

macdonaldm
New Contributor

Re: workaround for nested aggregation

Thank you!