This content has been marked as final. Show 2 replies
Please bare with me here, it has been a while since I have used Qlikview and my scripting kinda sux.
I have a table like below:
|Month||Difference in QV||Spend||Difference in Excel|
I am trying to get the spend difference between the latest period and the previous period.
In QV, I used this formula : if(RowNo() = 1,0,sum(cost) - Above(sum(cost)))
Please advise, what am I doing wrong here. Thanks a lot in advance.