Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Noor51
Creator
Creator

Funnel chart Number and percentage

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. 

Noor51_0-1757616293283.png

 

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)
)

 

 

Labels (3)
2 Replies
robert_mika
Master III
Master III

Can you upload your qvf?

Noor51
Creator
Creator
Author

I solved it using a container chart and have a separate chart for percentage.