topic Funnel chart in QlikView

Funnel chart

Anonymous — Wed, 26 Feb 2014 15:21:44 GMT

Hi,

I have 2 questions for you:

1. Why gradient colors in the funnel chart? Is it possible to use only solid colors?

2. I have the funnel chart with fix sort

Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm').

I'd like when I click on any segment, this segment keeps the same color and stay on the same place.

For example, if I click on the second segment from bottom, it keeps his color and stay on the same place, other segments will be colored grey color.

Please see my attached file.

Thank you,

Re: Funnel chart

jerem1234 — Wed, 26 Feb 2014 15:55:09 GMT

1. I don't believe so, that's how the chart is designed.

2. Take a look at attached. You needed to ignore selections in your sort with {1}, so I added the function only(). For the colors, I used a pick(match()) instead of the if statements, but I did need one if to handle nulls when selection was made.

Sorting:

Match(only({1}[qID_15876_Last step in cart]),'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm')

Colors:

if(Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm'),

pick(Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm'),

rgb(255,181,128), rgb(255,151,77), rgb(255,113,13), rgb(217,97,11),rgb(179,85,18)),

rgb(100,100,100))

Hope this helps!

Re: Funnel chart

jerem1234 — Wed, 26 Feb 2014 15:57:32 GMT

Actually for colors, this formula is better:

if(isnull([qID_15876_Last step in cart]), rgb(100,100,100),

pick(Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm'),

rgb(255,181,128), rgb(255,151,77), rgb(255,113,13), rgb(217,97,11),rgb(179,85,18)))

Re: Funnel chart

Anonymous — Wed, 26 Feb 2014 16:01:57 GMT

Thanks Jerem.