Many to One Calculated Dimension

[#1]

Is there a way to create a many to one relationship dimension with an expression?

What I am trying to get is something like this:

Dimension:

Company,

A,

B

C.

Chart:

Company            Sales

All                       350

A                         100

B                         200

C                         50

If I can create this then I believe there is a way to have users do custom groupings in ad hoc reports. They like to group a sub set of values and compare against the total and regular values. The only solutions I could find involved macros or grouping the dimension into groups keeping the one to one relationship, both of which would not work for my need.

[sunny_talwar]

May be use ValueList

Dimension

Pick(ValueList(1, 2), 'All', Company)

Expression

Sum(Sales)

[MarcoWedel]

Hi,

for the 'All' dimension values requirement you probably could use something like a dimensional link table:

https://community.qlik.com/servlet/JiveServlet/download/3451-6-46406/Generic%20Keys.pdf

(page 5)

Generic keys

Fact Table with Mixed Granularity

the dynamic grouping requirement on the other hand might be implemented like this (using macros though...):

grouping dimension values

hope this helps nevertheless

regards

Marco