Group Dimension from different Dimensions

[mnada2012]

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

[Digvijay_Singh]

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]

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]

Add alternative dimension

[mnada2012]

that will not work but thanks for your reply 

[Digvijay_Singh]

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

[mnada2012]

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

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