Correlation of two variables

nicalbert — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I'm currently working on a project where I need to compare the following:

The numbers of calls sent to a unit during a day (using vCalls as a variable)
The numbers of times a unit was assigned while doing an activity during a day (using vDistAct as a variable)
- In this environment, an "activity" can be daily vehicle check, meal period, end of shift cleaning period... And they can be either delayed or interrupted - but for this example, they are all considered "disturbed"

We are working under the assumption that a busier a day will be, the more chances a unit have to be assigned during an activity and I'd like to get the correlation between the two items. There is one - I've used Excel to get it, but now I need to add it to QV.

Given the fact that I need to exclude some data point using "IF" conditions (both in Calls and Activities), I am using variables to simplify the correlation expression. Attached is spreadsheet with the data for Calls and Activities - the number I need to use to create the Correl expression.

I've tried multiple times it QV to create a Correl expression, but I either get an error or a value of "-" (minus sign).

Anyone can provide assistance on that?

Regards,

Nic

Re: Correlation of two variables

nicalbert — Wed, 11 Jul 2018 15:16:25 GMT

Any one can provide assistance on that question?

topic Correlation of two variables in QlikView

Correlation of two variables

Re: Correlation of two variables