I have two columns: budget and gross margin. I want to know the correlations between the two columns divided according to the third column: countries. In other words, I want a graph that tells me the relationship between budget and gross margin among the countries. Originally I had 4 tables. I outer-joined them together to form one super-table. I then just use the correl function with with the bar charts with year and country as dimensions. The expression for the chart was as follows :
=Correl([Sales budgets.Budget],[Product data.Gross margin])
when I compared the results with those I had made on excel, they did not match. I am not sure whether the excel one is the correct one or the Qlik one is correct. I stumbled upon suggestions to use aggr, only to be told that it did not work. Is there a solution to this?
