Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a funnel chart in qlik sense on prem May 2025 version. I want it so that the chart show number and percentage difference between each filter in the chart. Here is the funnel chart and set expression for it.
Pick(
Match(
ValueList(
'Total Count',
'Request Data',
'Presentation Date',
'Sales Handoff',
'Pending Future Follow Up',
'Closed'
),
'Total Count',
'Request Data',
'Presentation Date',
'Sales Handoff',
'Pending Future Follow Up',
'Closed'
),
// 1 - Total Count (across all stages you care about)
Count(Distinct {<[Opportunity Stage] = {
'Introductory call',
'Request data',
'Touch base with sales',
'Sales Handoff',
'Future Follow-up',
'Won',
'Lost'}>} C360),
// 2 - Request Data
Count(Distinct {<[Opportunity Stage] = {
'Request data',
'Touch base with sales',
'Sales Handoff',
'Future Follow-up',
'Won',
'Lost'}>} C360),
// 3 - Presentation Date
Count(Distinct {<[Opportunity Stage] = {
'Touch base with sales',
'Sales Handoff',
'Future Follow-up',
'Won',
'Lost'}>} C360),
// 4 - Sales Handoff
Count(Distinct {<[Opportunity Stage] = {
'Sales Handoff',
'Future Follow-up',
'Won',
'Lost'}>} C360),
// 5 - Pending Future Follow Up
Count(Distinct {<[Opportunity Stage] = {
'Future Follow-up',
'Won',
'Lost'}>} C360),
// 6 - Closed
Count(Distinct {<[Opportunity Stage] = {
'Won',
'Lost'}>} C360)
)
Can you upload your qvf?
I solved it using a container chart and have a separate chart for percentage.