idea Re: Bar offset functionality added to QlikSense bar charts in Suggest an Idea

Bar offset functionality added to QlikSense bar charts

brocklewis — Mon, 23 Aug 2021 17:55:55 GMT

Within Qlik View, there existed for bar charts an option for each expression to 'Offset' (see image.) This was useful in many situations, and it would be excellent to have access to this option in Qlik Sense bar charts as well.

Re: Bar offset functionality added to QlikSense bar charts

cotiso_hanganu — Fri, 19 Nov 2021 16:49:24 GMT

Man, I have more than 3 years I am wishing someone in R&D to wake up and realise this should have been there for a long time !

The current Waterfall object is a bad joke compared with the options possible with this small addition !

I have used for years now the workaround with an additional invisible bar stacked underneath the visible one... but when you get into negative values for a P&L waterfall with more than several bars.... , it blows up in your face !

See in the following pictures some possible use cases.

Re: Bar offset functionality added to QlikSense bar charts

cotiso_hanganu — Fri, 19 Nov 2021 17:24:53 GMT

Ex1:

(QS) Dual What If with multiple Waterfall

using invisible stacked bars
formulas for the single offsett(ed) bars in the middle are pretty heavy, having to handle separately a lot of different situations (positive and negative values for the bar and for offsets on both ends...
=> at least 6 different if cases instead one simple formula 😞 )

(QS) multiple waterfalls for what if that are changing sign and colors... (using the current solution with invisible stacked bars is requiring huge formulas, despite there is only one bar with offset !

Ex2:

(QS) Dynamic P&L Waterfall with selectable bars

one formula only
conditional coloring by category and subcategory
Seemed ok, until we had to deal with negative intermediary margins or handle EITDA and EBIT and EBT for several business units
=> currently impossible to make it handle all the situations !!! 😞

(QS) P&L waterfall with conditional show (again made with stacked invisible bars) ... Already impossible to me to make the whole formula work

Ex3:

(QV) P&L waterfall with multiple bars (more than 10) and conditional coloring for negative values

if at least conditional coloring with expression in current waterfall object would be possible, this situation could be handled

(QV) Waterfall with many bars and conditional coloring for negative values - impossbile in QS at this number of columns)(QV) Subsequent waterfalls in time for bottom up Cash Flow projections with dynamic time dimension (have something in QS already, but formulas are crazy for 1 offseted bar, especialy when negative closing ballances are possible

Re: Bar offset functionality added to QlikSense bar charts

cotiso_hanganu — Fri, 19 Nov 2021 17:36:14 GMT

Ex 4:
(QV) Free Cash waterfall in time..

with starting & net in month & closing
3 formulas + 1 dimension + conditional formatting for the offseted bar + negative net in month + transparent coloring + overlapping bars

Ex 5:
(QV) Free Cash waterfall in time alligned with other waterfalls (first object is actually the same with the previous, just some additional conditional show of first and last expression

The other are also just declinations of the same object (having more the 20 expressions) with conditional shows on different criteria (selected by user in the interface) that have also in offset formulas additional conditions depending on the chosen conditions.
Even in QV , with offset formulas available , some of the offset formulas are very hard to handle....

But having to include the invisibles stacked bars... Impossbile !

Re: Bar offset functionality added to QlikSense bar charts

brocklewis — Tue, 28 Dec 2021 16:24:33 GMT

Thanks Cotisu,

Do you mind elaborating how you designed the below chart? The main reason that I want access to the bar offset option is so that we can monitor openings and closures of accounts from month to month, or quarter to quarter, etc. I knew how to do this in QlikView, but without a bar offset in Qlik Sense, it has eluded me so far.

Is this one dimension and many measures? Ie: one measure for each individual month? That is the only way I can think to do it

Re: Bar offset functionality added to QlikSense bar charts - Status changed to: Open - Collecting Feedback

Ian_Crosland — Wed, 12 Jan 2022 13:53:04 GMT

Re: Bar offset functionality added to QlikSense bar charts

cotiso_hanganu — Wed, 06 Apr 2022 21:27:05 GMT

It îs QlikView. Cannot do it inQlik Sense. That îs the Point of Asking Offset in Sense Barchart

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:07:51 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Bar offset functionality added to QlikSense bar charts - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:07:53 GMT