Diagram rename legend entries

[#1]

Hello everyone,

today a new Problem came up to me.

I'm using 2 tables:

Typs:

Typ	pID
typA	A.1
typB	A.2
typB	A.2
typC	B.1
typD	A.1
typD	B.2

Locations:

pID	Location
A.1	someName
A.2	someOtherName
B.1	dream
B.2	inTheAir

Further I have a Pie Diagram with dimension pID and formula COUNT(pID) from table Typs. By doing this I calculate the ratios of the locations correctly.

My problem is that in the legend of the diagram the names of Typs.pID will be used and I need to display the corresponding names of Locations.Location. I tried searching for similar issues and ended with no success...

So how do I replace A.1 with someName etc. in the legend of an diagram?

Thanks for your hints in advance.

[jonathandienst]

Hi

Then denormalise your model by bringing Location name into the Typs table - either by using a mapping table and ApplyMap or performing a join. Qlikview stores repeating non-unique values very efficiently.

Regards

Jonathan