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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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