Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
tellmalaika17
New Contributor II

Create one dimension out of multiple fields

Hi,

I have fields as Cost, Division(inline table field), Product in the data model. Cost is in different table, Division is part of inline table and Product is in Product table.  

Requirement is to create one field for all the above fields and name it as 'Costing'.

I tried creating this new field and using resident load but it doesn't work.

Kindly help.

 

Labels (2)
3 Replies
Partner
Partner

Re: Create one dimension out of multiple fields

not clear what you mean by "Requirement is to create one field for all the above fields and name it as 'Costing'."

share a sample data which reflects the multiple tables and a desired result

Channa
Valued Contributor III

Re: Create one dimension out of multiple fields

use inner join between all those tables .if you check your model it will create one final table

 

on top of that you try resident load cost&division&Product as Costing

Channa
dolpinee
New Contributor

Re: Create one dimension out of multiple fields

Hi,

I do have a sound similar question. I was QlikView user earlier and have recently get in touch on Qlik Sense. In QlikView, there is possible to have a few dimensions grouped into 1 dimension label which allowed user to choose what they would like to analyse on. 

As per example below taken from QlikView dimension - this curve arrow when being right click, user is able to switch from 1 dimension to another in one of the column within a table. Can this be done in Qlik Sense?

clipboard_image_0.png

Thanks

Tags (2)