Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manideep78
Partner - Specialist
Partner - Specialist

IF Statement to Set Analysis in Concat() function

Dear Community,

Please write the below expression in set analysis without using IF Statement.

=Concat(IF(aggr(Sum(Revenue),Product)>300,Product),',')

Thanks in advance.

Regards,

Manideep

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

Try:

=Concat({<Product = {'=sum(Revenue)>300'}>}Product, ',')

Hope this helps!

View solution in original post

2 Replies
jerem1234
Specialist II
Specialist II

Try:

=Concat({<Product = {'=sum(Revenue)>300'}>}Product, ',')

Hope this helps!

manideep78
Partner - Specialist
Partner - Specialist
Author

Perfect! Thank you