Discussion Board for collaboration on QlikView Scripting.
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:
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.
Go to Solution.
If you need percentage, then may be this:
If(RowNo() = 1,0, (Sum(cost) - Above(Sum(cost))/Above(Sum(cost)))
Thank you, Sunny. Will try.