Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hidehuman
Contributor II
Contributor II

How to make correlation chart between two values grouped by fields

 

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? 

Labels (4)
0 Replies