topic How do I create this funnel chart? in QlikView

How do I create this funnel chart?

G_Hofstedt — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How do I create this funnel chart?

zhadrakas — Tue, 27 Feb 2018 08:27:51 GMT

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

Re: How do I create this funnel chart?

fvelascog72 — Tue, 27 Feb 2018 08:31:39 GMT

Hi,

Try with this:

Saludos

Re: How do I create this funnel chart?

siddharth_s3 — Tue, 27 Feb 2018 08:36:28 GMT

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

Re: How do I create this funnel chart?

G_Hofstedt — Tue, 27 Feb 2018 09:21:26 GMT

Thanks, it seems to work