Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikrjhamnz
Contributor II
Contributor II

MutualInfo function - how to use

I saw this dmeoed at Qlikworld 2021 and see the function is available in script editor, but cant find anything in online help. 

Does anyone have this information as well as any on using the new timeseries featurein insight advisor

Thanks in advance

Rodney

2 Replies
RSvebeck
Specialist
Specialist

Maybe you should split up your questions in two posts?

Here is what I have tested on MutualInfo()
The simple syntax is: MutualInfo(TargetField,DriverField,Datatype)

You can add more input values after DataType but I'm not sure how to use those yet.

Datatype is not clear to me but on the session he talked about two discrete fields as Target and Driver, and then added 'dd' as data type, which makes me guess that continuous fields has a 'c' as datatype and discrete fields has 'd' so if your target is discrete and driver continuous (numeric) you enter 'dc' as data type. I tried this and it seems to work, but I am just guessing here...

The mutualinfo() will return a value between 0 and 1. The more related the Driver field is to the Target field, the closer it will be to 1. For instance if you enter the same field in Driver and Target you should get value = 1. and if there is no relation, for instance if you take orderNo as Driver and Churn as Target, you should be close to Zero.

Hope that helps.

Robert

Svebeck Consulting AB
rwunderlich

New features tend to show up in the SaaS doc before the windows doc

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Statistic...

-Rob