Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
madhudinesh
Partner
Partner

Issue with offset in Stacked Waterfall Chart

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.

Dim1Dim2
AA1
BB1
CC1
CC2
DD1
DD2
DD3
DD4
DD5
DD6

 

Labels (1)
1 Reply
edwin
Specialist III
Specialist III

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