Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mnada2012
New Contributor III

Group Dimension from different Dimensions

Hi,

I am new to Qlik sence, I have question

I have dimension called product group and another one called Price Group and third called Sales Man

now what I need is to create a new dimension called Business area where it is a selection of value of these 3

for example

DRY Business is selection of some product group and some of price group and one sales man like that

what is the best way to achieve that I am connecting to SAP through SAP connector

Tags (1)
6 Replies
Digvijay_Singh
Honored Contributor III

Re: Group Dimension from different Dimensions

You need to create new calculated field in script as 'Business area' and it should populate like this -

if("product group" = 'some prod group' and "Price Group" = 'some price group' and "Salesman" = 'some sales man',

'DRY','NO_DRY') as [Business Area]

mnada2012
New Contributor III

Re: Group Dimension from different Dimensions

Thanks Digvijay

but in this case if we need to add any new product group or change sales man I have to change the code right

there is no way to read that from excel

ChennaiahNallani
Contributor III

Re: Group Dimension from different Dimensions

Add alternative dimension

Capture.PNG

Highlighted
mnada2012
New Contributor III

Re: Group Dimension from different Dimensions

that will not work but thanks for your reply 

Digvijay_Singh
Honored Contributor III

Re: Group Dimension from different Dimensions

Calculated dimension is one of the option, can you share the logic needed to build this dimension and some sample data?

mnada2012
New Contributor III

Re: Group Dimension from different Dimensions

Hi Digvijay,

bellow is 3  Dimention that standard in the Query

now I wan to create a new one which is going to be a selection of these 3

Capture.PNG

like this in SAP bex Qeruy where we can create a selection or structure

Query.PNG