Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
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
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!