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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
coloful_architect
Creator II
Creator II

only function with set expression for dimension

Hi community,

I have a table with business name, units, manufacturers. each business name could have multiple manufacturers.

I want to have a plan table with the field of business name to only show manufacturers count larger than 1 and its units% less than 60%. tried this at dimension of business name. but does not work out. 

any idea?

 

=aggr(only({<[Business Name]={"=count(distinct Manufacturer) > 1"},


max(aggr(sum([Pack Units]),[Business Name],Manufacturer))

/
sum([Pack Units])={'<60%'}>

 

} [Business Name]),[Business Name])

0 Replies