Offset in bar chart Qliksense

sujayrpatil — Thu, 08 Oct 2020 08:29:31 GMT

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 >

And the required result is as below :

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.

topic Offset in bar chart Qliksense in App Development