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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
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