Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
markusblaut
Contributor III
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())) ),))

0 Replies