Return null when rangesum reach max value

[tan_chungkam]

Hi Qlikers,

I have below straight table and line chart showing accumulated progress.

I would like to return the figure to null from 2nd 100% onward.

My Original Table

Please find below my desire outcome.

My desire straight tableMy desire line chart

[sugathirajkumar]

if(sum(Progress)<>'0',rangesum(above( Sum([Progress]),0,rowno())),'Completed')

[sugathirajkumar]

[Arthur_Fong]

Try doing rangesum at script:

Refer attached qvf for reference.

Thanks and regards,

Arthur Fong

[tan_chungkam]

HI @Arthur_Fong ,

there is nothing in your attached qvf.

I don't see any script either formula in the table.

[tan_chungkam]

@sugathirajkumar ,

Thank you for you solution.

It works. However i have another question.

What is my first week start with a 0%. I would like to see 0% instead of a 'Completed' word.

[Arthur_Fong]

Sorry that i have overwrite the file.

Refer below is the updated qvf.

Thanks and regards,

Arthur Fong

[sugathirajkumar]

=if(Sum(Progress)<>'0' and rangesum(above( Sum([Progress]),0,rowno())) <>'100',rangesum(above(Sum([Progress]),0,rowno())),'Completed') This will work perfect