Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Find attached.
use offset like so
if (RowNo()>1, (Top(Sum(Value)) - sum(Value)) / 2,0)
You mean in qliksense? (assuming because of the subcommunity)
if so use the funnel chart from visualization bundle
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?
@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.
Use a Bar Offset expression of:
if (RowNo()=1, 0, (Top(Sum(Value)) - sum(Value)) / 2)
-Rob
The bar chart looks great.
Can you please share the qvw?
I'm trying to achieve it in Qlikview.
Find attached.
use offset like so
if (RowNo()>1, (Top(Sum(Value)) - sum(Value)) / 2,0)
You're amazing, thanks a lot @dplr-rn