How do I create this funnel chart?

[G_Hofstedt]

I want to group invoices / amounts as shown below. An invoice of 50 will thus end up in all three groups. The groups consist of 500 or less, 250 or less, and 100 or less. An invoice of 450 should only end up in the first group.

How do I solve this? When I try with nested If statment invoice of 50 only group in the first category.

[zhadrakas]

try with no Dimension an Expressions like this:

count(if(Invoice<=500 AND Invoice>250 , Invoice))

count(if(Invoice<=250 AND Invoice>100 , Invoice))

count(if(Invoice<=100, Invoice))

[fvelascog72 · Accepted solution]

Hi,

Try with this:

Saludos

[siddharth_s3]

If you are using Qlik Sense, you can find an extension.

[G_Hofstedt]

Thanks, it seems to work