How to link category group values to category group?

Douwe_KB — Thu, 30 Mar 2023 12:52:05 GMT

Hello,

I have a field called [Klantinformatie], which stores data about customers, such as to which category of businesses they belong:

[Klantinformatie]: LOAD [ABAN8] as "Klantnummer", [ABALPH] as "Klantnaam", //[ABAT1] as "Klanttype", [ABAC01], ApplyMap('MapDC', ABAC01,'-') as "Vestiging", [ABAC03], ApplyMap('MapVertegenwoordiger', ABAC03,'Intern') As "Vertegenwoordiger", [ABAC06], ApplyMap('MapKlantgroep', ABAC06,'-') as "Klantgroep" FROM [lib://QlikView JDE extractie/F0101.QVD] (qvd);

I also have a seperate file which stores the category of business + product category and the desired percentage of sales per product category, which looks as follows:

Which I load in as follows:

Koppelingen: LOAD Koppeling, Percentage FROM [lib://AttachedFiles/Koppelinggg.xlsx] (ooxml, embedded labels, table is Blad1);

Suppose I have a company "Test" which belongs to the "CAT" category of businesses. How do I map these values for all product categories to the "CAT" category?

All help is appreciated!

Re: How to link category group values to category group?

Or — Thu, 30 Mar 2023 13:02:58 GMT

The above doesn't seem to contain a field called Klantinformatie (that's the internal name of the table, but not a field), nor a field called Company, so I'm a bit confused as to what you're trying to do exactly.

Generally speaking, if you have a table that contains Company and Koppeling, it will automatically create a key to the Koppeling field in the existing load by virtue of identical field names.

topic How to link category group values to category group? in App Development

How to link category group values to category group?

Re: How to link category group values to category group?