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: 
mnada2012
Contributor III
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

6 Replies
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
Contributor III
Contributor III
Author

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
Creator III
Creator III

Add alternative dimension

Capture.PNG

mnada2012
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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