overwrite value of the expression

[#1]

Hi,

I have a table with one dimension and one row. I want to overwrite the value of expression in one row with the value of the previous.

How that can be done?

[MarcoWedel]

can you give an example?

You lost me at the point where a single row table has previous rows ?!?

regards

Marco

[#3]

Hi,

I have attached spreadsheet coming out from the table in Qlikview with the red number in one of the rows. This is where I want to have a negative value from the previous row. In the spreadsheet I added a line of code how I am trying to achieve it,

Regards,

Olivera

[jagan · Accepted solution]

Hi,

Try like this

If([Status Current] = '3. Total Active Unallocated', Above([Unallocated to Allocated]), "Actual Expression")

Note: In above expression replace "Actual Expression" with your expression.

Regards,

jagan.

[#5]

Hi,

thank you all,

Above function worked here,

Regards,

Olivera

[jagan]

Hi,

Please close this thread if you got the answer by giving correct and helpful answers.

REgards,

Jagan.