Issue with offset in Stacked Waterfall Chart

madhudinesh — Fri, 15 Nov 2024 23:24:42 GMT

Hello,

I have created a stacked Waterfall chart with 2 dimensions (as below).

In the chart, the Dim2 will be grouped under Dim1. The Dim2 consists of 10 values relating to 10 different metrics.

1 expression is used (Used pick, Match function to map 10 different formulas to values in Dim2).

So, the Dim1 - A and B will have a single Bar, C will have stacked chart with C1 and C2 (2 metrics), D will have stacked chart with D1,D2,D3,D4,D5,D6 (6 metrics). PFA image for reference.

I am facing issue with the position of 'C' (Dim1) only during some random selections made in the year, quarter, month and week filter. (this bar doesn't align to the axis value and moves above value of A).

Eg. even if value of offset is 6000, it is in position of 10000.

Bar Offset- The formula of A1-B1-C1-C2. This offset has been set to C2.

The position of other bars are as expected during any selections.

Requesting your help on this issue.

Dim1	Dim2
A	A1
B	B1
C	C1
C	C2
D	D1
D	D2
D	D3
D	D4
D	D5
D	D6

Re: Issue with offset in Stacked Waterfall Chart

edwin — Wed, 23 Dec 2020 17:39:15 GMT

posting a qvw would help others investigate your issue. the pic may not be enough

topic Re: Issue with offset in Stacked Waterfall Chart in QlikView

Issue with offset in Stacked Waterfall Chart

Re: Issue with offset in Stacked Waterfall Chart