Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SkitzN27
Creator
Creator

Display bar chart with Offset

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  @dilipranjith   @Kush  @Taoufiq_Zarra 

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

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

Find attached.

use offset  like so

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

 

View solution in original post

7 Replies
dilipranjith
Partner
Partner

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

if so use the funnel chart from visualization bundle

SkitzN27
Creator
Creator

Hi @dilipranjith 

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?

Kush
MVP
MVP

@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. 

Screenshot 2020-11-04 225319.png

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.

Screenshot 2020-11-04 225115.png

 

rwunderlich
MVP & Luminary
MVP & Luminary

Use a Bar Offset expression of:

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

-Rob

SkitzN27
Creator
Creator

Hi @Kush 

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

dilipranjith
Partner
Partner

Find attached.

use offset  like so

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

 

View solution in original post

SkitzN27
Creator
Creator

You're amazing, thanks a lot @dilipranjith