Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am making a KPI for lead generation. We have various stages the leads go through (3). F1=the lead is created, F2= the lead is qualified as good F3=Closed deal
I want to make a KPI for leads that were created on a period of time and closed on that same period of time.
How can I do that on Qlik Sense?
Hi Esteban,
There are many ways to achieve what you need:
Maybe if you share your model we can help you easier...
Regards,
H
My model for this app is way too simple, I think. I uploaded everything with the data import editor wizard (Gestor de datos) and everything I need lives in one table 'sf_lead'. Qlik identified the data types for every column so I didnt need to make a master calendar. Actually I think i have multiple calendars, since every date has their Q, Day, Month, Year,etc automatically.
Here are my KPIs:
Here's how I calculate it: (count({$<[rating]={'cerrado'}>} id))/(count({$<[faseopp__c]={'F2'}>} id))
What I want to achieve is the last 'F2/Cierres' Measure having F2 from one month and closed deal (cierre) from that month too. No closed deals from another month from the creation, just the one created on the same month.
Thanks for your help