topic Re: Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions in QlikView

Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions

Fri, 28 Feb 2014 18:50:48 GMT

Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions?

Re: Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions

Anonymous — Fri, 28 Feb 2014 19:05:38 GMT

Something like this (typical pharma Reach and Frequency)?
I'm not sure what you mean by ranking in this case, but making selections is fine.

Re: Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions

Fri, 28 Feb 2014 19:12:28 GMT

Yes, looks very close. Did you loop all possible combination in the script?

Re: Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions

Anonymous — Fri, 28 Feb 2014 19:29:23 GMT

Nothing like that in the script. Calculations on the front end.

Chart Reach.

Calculated dimension
=aggr(if(sum(NumOfPres)>0, 'Presented','Not Presented'), Name)

Expression

count(distinct Name)

Chart Frequency

Calculated dimension

=aggr(if(Sum(NumOfPres)<6,text(sum(NumOfPres))&' Presentations','6+ Presentations'),Name)

Expression is the same as for Reach.

The field NumOfPres in my case is calculated in the script, count of Presentations grouped by Product, Time, and Customer. That means if you make selections on the front end, your charts are recalculated. If I didn't aggregate it, calculated dimensions would use count(distinct Presentations) instead of sum(NumOfPres). The rest is the same.

Re: Re: Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions

Fri, 28 Feb 2014 20:07:48 GMT

This is what I am planning to get

TURF Summary
	Portfolio size	Reach (%)
Came from a Dealers website to search inventory	1	28.85
Other, please specify:+Came from a Dealers website to search inventory	2	56.15
Seeing XXX vehicle on the road+Other, please specify:+Came from a Dealers website to search inventory	3	70.38
Online search results+Seeing XXX vehicle on the road+Other, please specify:+Came from a Dealers website to search inventory	4	80.38
Online advertisement+Online search results+Seeing XXX vehicle on the road+Other, please specify:+Came from a Dealers website to search inventory	5	86.92

TURF Analysis: Portfolio size=1
	Reach (%)
Came from a Dealers website to search inventory	28.8462
Other, please specify:	28.4615
Seeing XXX vehicle on the road	17.3077
Online search results	15.3846
Online advertisement	11.9231
Word of mouth recommendation	10.7692
Television advertisement	8.8462
Test drive of XXX	6.1538
Social media	3.4615
Print advertisement	3.0769
Radio advertisement	1.1538
Blog/online article	0.3846

TURF Analysis: Portfolio size=2 - top 5
	Reach (%)
Other, please specify:+Came from a Dealers website to search inventory	56.1538
Seeing XXX vehicle on the road+Other, please specify:	45
Seeing XXX vehicle on the road+Came from a Dealers website to search inventory	43.8462
Online search results+Other, please specify:	42.6923
Online search results+Came from a Dealers website to search inventory	40.7692
TURF Analysis: Portfolio size=3 - top 5
	Reach (%)
Seeing XXX vehicle on the road+Other, please specify:+Came from a Dealers website to search inventory	70.3846
Online search results+Other, please specify:+Came from a Dealers website to search inventory	67.3077
Online advertisement+Other, please specify:+Came from a Dealers website to search inventory	65.7692
Word of mouth recommendation+Other, please specify:+Came from a Dealers website to search inventory	64.2308
Television advertisement+Other, please specify:+Came from a Dealers website to search inventory	63.4615