Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Re: overwrite value of the expression

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 Replies

Re: overwrite value of the expression

can you give an example?

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

regards

Marco

Not applicable

Re: Re: overwrite value of the expression

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

MVP
MVP

Re: overwrite value of the expression

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

Re: overwrite value of the expression

Hi,

thank you all,

Above function worked here,

Regards,

Olivera

MVP
MVP

Re: overwrite value of the expression

Hi,

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

REgards,

Jagan.

Community Browser