Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
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.
can you give an example?
You lost me at the point where a single row table has previous rows ?!?
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,
thank you all,
Above function worked here,
Please close this thread if you got the answer by giving correct and helpful answers.