Funnel Chart Expression

[Noor51]

Hi Everyone, 

I would appreciate help in being able to set up a funnel chart in Qlik sense on prem Nov 2024 patch 8. 

I have a dimension call "Stages" that has 3 values in it called "Intro", "Hand_Off", and "Close". 

I need a funnel thats in this order total count of "Stages" then "Total Stages - Intro" and etc.

What  would be set expression for this.

[MatheusC]

Hi, @Noor51 
In the sorting tab, select by expression and with dual() and match() assign the order

dual(Dim,match(Dim,'value1','value2','value3'))

- Regards, Matheus

[anat]

create a Inline load 

load * inline [

stage,stage_ord

Intro,1

Hand_Off,2

Close,3

Total Stages,4

]

in the sort expression use sort by expression then useonly({1}stage_ord)

[Noor51]

I have master measure, I want to organize it rows in this way, but isn't working. 

ValueList(
[Total Count],
[Introductory call],
[Request Data],
[Presentation Date],
[Sales Handoff],
[Pending Future Follow Up]
)

[Kaushik2020 · Accepted solution]

You may create a mapping inline load with a column SerialNumber with the numeric data in it. further you ca n sort it as Ascending or Descending based on requirement. let me know further.