Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Use a Description as a dimension but aggregate by unique id

Hi

Apologies if this is very simple. I have a unique id column and a description column (company name) which may not be unique. I want to display the company names as a dimension on a chart but ensure that if 2 companies have the same name their measures e.g. turnover are not summed together and treated as 1 value, thus I want to aggregate using the unique identifier.

Many Thanks

Paul

Tags (1)
2 Replies
prieper
Honored Contributor II

Use a Description as a dimension but aggregate by unique id

Easiest way might be to use a calculated dimension like
Name & ' (' & ID & ')'

Peter

MVP
MVP

Use a Description as a dimension but aggregate by unique id

That's what I do, or more accurately, when names are not unique, I just add the ID to the name field. After all, if two companies have the same name, you still need to be able to distinguish between them in SOME way.

Community Browser