Display bar chart with Offset

[SkitzN27]

Hi guys,

Thanks for always helping me out.

I want to know if its possible to create a qlikview  bar chart like this which looks like a funnel? 
(I believe I'll have to use some Bar offset feature, but I'm not sure how to do it)

Can someone please help?

Sample Data:

Load * in line [

Phases, Value

Phase 1, 5000

Phase 2,  4000

Phase 3, 3000

Phase 4, 1000

Phase 5, 250

Phase 6, 100

Phase 7, 94

];

Thank you so much

N

@MayilVahanan  @dplr-rn   @Kushal_Chawda  @Taoufiq_Zarra 

The real data consists of millions of values, so just want the chart to behave accordingly.

[dplr-rn]

You mean in qliksense? (assuming because of the subcommunity)

if so use the funnel chart from visualization bundle

[SkitzN27]

Hi @dplr-rn 

No, I meant in Qlikview.

I don't want to use a funnel chart but use a bar chart like this.

Or is there any way to make a funnel chart look like the one above?
The one you see above is a bar chart with dimension (phase) on the y axis.

Does it make sense?

[Kushal_Chawda]

@SkitzN27  I would suggest to use the Qlik sense's Funnel chart itself with Funnel mode "Width" which is almost similar to what you want. 

If you still want it in Bar graph then below is what best you can get. You will be able to show % on mouse hover using dual function instead of value label as we are using stack bar option here.

[rwunderlich]

Use a Bar Offset expression of:

if (RowNo()=1, 0, (Top(Sum(Value)) - sum(Value)) / 2)

-Rob

[SkitzN27]

Hi @Kushal_Chawda 

The bar chart looks great.
Can you please share the qvw?
I'm trying to achieve it in Qlikview.

[dplr-rn · Accepted solution]

Find attached.

use offset  like so

if (RowNo()>1, (Top(Sum(Value)) - sum(Value)) / 2,0)

[SkitzN27]

You're amazing, thanks a lot @dplr-rn