Correlation matrix

[qlikeers]

We assume that we have the following fields in the extensive data model:
- InvoiceID – invoice number
- InvoiceDate – invoice date
- CustomerID – customer number
- CustomerName – customer name
- OrderID – order number
- ProductID – product number
- ProductName – product name
- ProductLineID – product line (grouped products by category)
- ProductLineName – product line name
- ProductGroupID – product group
- ProductGroupName – product group name
- ProductSubGroup – product subgroup
- ProductBrand – product brand
- SalesQty – number of units sold
- SalesPrice – sales price
- SalesValue – sales value, as SalesQty* SalesPrice

I'd like to create a correlation matrix, using the simplest method possible. I'd like to examine the relationship between each ProductLineID pair, taking into account SalesValue, and display this in the matrix. Then, for each ProductLineID, calculate the average of all the results and display it in a second table.

Do you have any ideas on how to do this?

[robert_mika]

Did you you try using grid Chart or pivot tables? Old post but the same principle https://community.qlik.com/t5/Visualization-and-Usability/How-do-i-create-a-matrix-or-the-two-dimens...

[qlikeers]

Yes, I have tried many ways, including this style, but I have not managed to do it correctly yet.