Retain fixed columns in a table with NULL records

[newqlik2017]

Using NULLASVALUE didn't seem to fix the below issue. Any suggestions, please? Attached is the sample qvw.

Current dataset:

Current dataset after applying filter:

Expected dataset after applying filter (Low and High columns should retain their values)

 

Low	High	Policy	Amount
50	100	2	90
100	500	5	450
500	1000

[sunny_talwar · Accepted solution]

Try this

=count(Policy) + Sum({1} 0)

= sum(Amount) + Sum({1} 0)

[newqlik2017]

Nice, thank you.