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: 
Not applicable

Many to One Calculated Dimension

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.

2 Replies
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