Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sujayrpatil
Partner
Partner

Offset in bar chart Qliksense

Hello all,

I have to create a waterfall using a Bar chart. So I am creating offset using stacking.

Below is the sample data I have >

Dim 1CountOffset
A1000
B151
C201
D301
E101

 

And the required result is as below :

Dim 1 Dim 2Count
AOffset0
AValue100
BOffset85
BValue15
COffset65
CValue20
DOffset35
DValue30
EOffset25
EValue10

 

Here when the Offset is 0, result should be 0. when Offset is 1, result should be  count of previous Dim 1 - count of Dim1.

for example : For DIM1 = B and DIM 2 = 'Offset', result should be count of A - count of B ( 100 -15) = 15.

For DIM1 = C and DIM 2 = 'Offset', result should be count of B- count of C ( 85-20) = 65.

For DIM1 = D and DIM 2 = 'Offset', result should be count of C- count of D( 65-30) = 35 and so on.

Request for your suggestions.

 

Thanks In advance.

Regards,

Sujay.

 

0 Replies