Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

overwrite value of the expression


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?

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

5 Replies
MarcoWedel

can you give an example?

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

regards

Marco

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Hi,

thank you all,

Above function worked here,

Regards,

Olivera

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

REgards,

Jagan.