Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jonah-vq
Not applicable

Create (master)dimension based on other dimensions

Hello,

I'd like to create a (master)dimension based on two other fields.

   

ID groupID functionID
AABC1
AABC2
APMO3
APMO4
BBFG5
BBFG6
BKJT7
BKJT8


=> create field ID-ADC where I only have the ID's for ID group "A" but excluding the "ID function" PMO

Thanks in advance!

1 Solution

Accepted Solutions
aarkay29
Not applicable

Re: Create (master)dimension based on other dimensions

May be this

If([ID group] = 'A' AND Not Match([ID function],'PMO'), [ID group] &'|'& [ID function]) as MasterDimension

1 Reply
aarkay29
Not applicable

Re: Create (master)dimension based on other dimensions

May be this

If([ID group] = 'A' AND Not Match([ID function],'PMO'), [ID group] &'|'& [ID function]) as MasterDimension