How to calculate roll ups in a Straight Table

[#1]

Hello,

I have a table with a set of retailers. Those retailers roll up into another set of parent retailers. The data is collected on the child/single retailer. How can I set up my data model and chart expressions to show all the retailers including the parents together in one table?

In the data table, each retailer has a set of distinct persons and their ratings.

The retailers are shown below:

The associate with the parent is shown below:

I can add the parent codes to the table above so that there are 3 more rows if necessary. But that is the extent of the manipulation I can do to the data that is imported into Qlikview

Retailer     Retailer Parent

100            100

200             200

300             300

How can I calculate the count of distinct persons for the retailer parents?

[Gysbert_Wassenaar]

I can add the parent codes to the table above so that there are 3 more rows if necessary. But that is the extent of the manipulation I can do to the data that is imported into Qlikview

Retailer     Retailer Parent

100            100

200             200

300             300

Instead of adding the Parents as Retailers with themselves as Parent you need to add the children to that table with themselves as their own parent. So every Retailer is linked to itself as parent and also with its real parent. Then you can use RetailerParent as dimension in your chart and everything will roll up correctly. The Type field should move from the Retailer table to the RetailerParent table too.

[#3]

I used a mapping load to add the parent retailers into the raw data.