Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

Accumulated values

Hi together,

Please check die following chart and formula. I Would like to have instead of the red marked bars an empty gap. Because I don't have any values for February, March...

So instead of the accumulated values I would like to see an empty gap.

Is this possible? Thank you very much for your support!

Best Markus

If(FY_2017_IST = '2017',
(RangeSum(above(Sum({<FY_2017_IST = {'2017'} >} [Ist]),0,rowNo())) ),

If(FY_2018_IST = '2018',
(RangeSum(above(Sum({<FY_2018_IST = {'2018'} >} [Ist]),0,rowNo())) ),))