Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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  @dplr-rn   @Kushal_Chawda  @Taoufiq_Zarra 

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

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Find attached.

use offset  like so

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

 

View solution in original post

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

if so use the funnel chart from visualization bundle

SkitzN27
Creator
Creator
Author

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. 

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
Partner Ambassador/MVP
Partner Ambassador/MVP

Use a Bar Offset expression of:

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

-Rob

SkitzN27
Creator
Creator
Author

Hi @Kushal_Chawda 

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

dplr-rn
Partner - Master III
Partner - Master III

Find attached.

use offset  like so

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

 

SkitzN27
Creator
Creator
Author

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