topic Concatenate Dimension Values in QlikView

Concatenate Dimension Values

sjhussain — Mon, 30 Nov 2015 10:58:05 GMT

Hello,

Hope everyone is fine.

We are working on a consultancy project in which we want to find out whether a project is worked by multiple companies.

We have the Project#, Count of Project per Company and the Company name as dimension.

For examples

Project Name, No. of Companies worked on Project

Proj002340, 3

Proj003430, 2

Proj001223, 2

Proj003452, 1

Now we have Company Dimension with the following Data

Company1

Company2

Company3

Company4

What we want to display is the following:

Project Name, No. of Companies, Company Name (Concatenated with '-')

Proj002340, 3, Company1-Company2-Company3

Proj00340, 2, Company2-Company3

Proj001223, 2, Company3-Company4

Proj003452, 1, Company2

We want to use Set Analysis if possible.

Will appreciate if someone can assist.

Thanks.

sunny_talwar — Mon, 30 Nov 2015 11:01:36 GMT

Not sure why you want to use set analysis here to concatenate values. For dimension may be this:

Aggr(Concat(DISTINCT [Company Name], '-'), [Project Name])

tresB — Mon, 30 Nov 2015 11:03:20 GMT

If the tables are associated (possibly with a Company key), you can simply take a straight table:

Dim: [Project Name]

Exp: Concat ( Distinct [Conpany Name] , ' - ')

sjhussain — Mon, 30 Nov 2015 11:04:19 GMT

Sunny,

Thanks you very much for the prompt response.

Excellent!

sunny_talwar — Mon, 30 Nov 2015 11:07:13 GMT

No problem, as long as you got what you were looking for, it is all good