Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mnada2012
New Contributor

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

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

mnada2012
New Contributor

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

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

Community Browser