Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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.