Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Aggregate dimension in some cases

Hi,

it's possible to aggregate one subDimension in some cases ?

for example

i have

sales for products ; and products in categories

i want this dimensions

Category

   +ProductName

   +Others (in this case i want sumarize in one condition)

Expressions

   Sum(sales)

   Sum(quantity)

thanks

Ricardo

2 Replies
sunny_talwar

swuehl
MVP
MVP

Which products should be included in 'Others' and which should be put separately?

Maybe try something like

=If( Match(ProductField, 'A','B','C'), ProductField, 'Other')

as calculated dimension.