peek with If condition

[upaliwije]

Hi Friends

I have developed  the attached QVW file with help from the friends in community. Now I have come the final stage where I do not get the expected output. In otherwords in my data table if the Two Policy nos match and Monthend period match and NEP+NEP (of two policies )is zero NEP amount sholud show Zero in both policies(rows). I have attched my QV docoment. Kindly look into this and help me,

Current output report

Required Output Report

[petter]

It is doable like you can see here. But the expressions and the tweaking that is necessary really make me think that we are stretching the limits on how far one should go to emulate a Spreadsheet oriented way of calculating in QlikView. It is much better to rethink the calculation model and come up with a model that is natural for QlikView's way of working.