Community
This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.