I am trying to do a covariance matrix in QlikSense. Here is a sample of data:
, product AS product_2
, price AS price_2
customer, product, price
The duplicate dimensions are so that I can do a pivot table with 'product' as rows and 'product_2' as columns (QS does not permit the same dimension to be used for rows and columns) then using as the measure: RangeCorrel(Aggr(max(price), product), Aggr(max(price_2), product_2)) but this does not work.
If I change the measure formula to Correl(price, price_2) I can get the value of 1 on the diagonals, but notihng else.