Problem with Above Function. Resets when the dimension changes

Mon, 10 Jan 2011 17:24:32 GMT

Hi everybody, I have a problem with the function Above. I've made a Single Table to check the balance of my Bank Account and the balance in my ERP. I have to dimensions: YEAR and MONTH. The problem is in the expression "Balance NAV" which has this formula:

"Amount NAV" + IF(ISNULL(Above ("Balance NAV")),0,Above ("Balance NAV"))

With this formula I try to have an "acumulated balance", but when the year change (and so the RowNo reset and begins again with 1) the formula does not work. Because the value of Balance NAV in Ene (January ) /2010 should be 93907.05 + 5640.42 = 99547.47.

Does anybody know how to avoid this "reset"?

Thanks a lot.

Problem with Above Function. Resets when the dimension changes

pover — Mon, 10 Jan 2011 18:32:36 GMT

Pedro,

Try using the Total modifier:

above(total Balance.Nav)

Regards.

Problem with Above Function. Resets when the dimension changes

Tue, 11 Jan 2011 08:04:00 GMT

That`s it. Thank you!!!

topic Problem with Above Function. Resets when the dimension changes in QlikView

Problem with Above Function. Resets when the dimension changes

Problem with Above Function. Resets when the dimension changes

Problem with Above Function. Resets when the dimension changes