Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr

Can you tel me how to include set in this expression upper(aggr(Country,Country)) , i want to exclude three other field selection in this list box using set analysis.

5 Replies
sunny_talwar

Try this:

Upper(Aggr(Only({<Set Analysis Here>} Country), Country))

Not applicable
Author

how to excludes field here?

sunny_talwar

What exactly are you trying to exclude? May be something like this:

Upper(Aggr(Only({<Field1 -= {'ABC', 'DEF'}>} Country), Country))

MK_QSL
MVP
MVP

=Aggr(Only({<Country -= {'A','B'}>}Country),Country)

Kushal_Chawda

upper(aggr(Ony({<Field1=,Field2=,Field3=>}Country),Country))

This will exclude the selection of Field1, Field2 & Field3