Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

markusblaut
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())) ),))