Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

output results of Set Analysis expression as opposed aggregating results

Hello,

I have the following expression which I wanted to put into a Text Box in QV

=count({<ProductID = p({<_NewProduct_flag ={1}>} ) >}  ProductID)

However, I do not wish to aggregate it, I would just like the text Box to display its output.

When I remove an aggregation funciton, count() in this case, I am not able to evaluate this expression.

How can this be accomplished in QV?

Thanks

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

If you are looking to see the ProductIDs instead of counting them, try concat() like:

=concat( Distinct {<ProductID = p({<_NewProduct_flag ={1}>} ) >}  ProductID, ',')

View solution in original post

1 Reply
Highlighted
MVP
MVP

If you are looking to see the ProductIDs instead of counting them, try concat() like:

=concat( Distinct {<ProductID = p({<_NewProduct_flag ={1}>} ) >}  ProductID, ',')

View solution in original post