topic Re: Funnel Chart Expression in App Development

Funnel Chart Expression

Noor51 — Wed, 30 Jul 2025 15:37:19 GMT

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.

Re: Funnel Chart Expression

MatheusC — Wed, 30 Jul 2025 16:40:27 GMT

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

Re: Funnel Chart Expression

anat — Wed, 30 Jul 2025 16:53:02 GMT

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)

Re: Funnel Chart Expression

Noor51 — Tue, 05 Aug 2025 18:21:03 GMT

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

Re: Funnel Chart Expression

Kaushik2020 — Wed, 06 Aug 2025 08:20:10 GMT

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.