Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
macdonaldm
Contributor
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
Channa
Specialist III
Specialist III

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

try

Channa

View solution in original post

2 Replies
Channa
Specialist III
Specialist III

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

try

Channa
macdonaldm
Contributor
Contributor
Author

Thank you!