Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Did anyone try to implement TURF analysis in Qlikview for multiple select and/or ranking questions?
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.
Yes, looks very close. Did you loop all possible combination in the script?
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.
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 |