Discussion board where members can get started with Qlik Sense.
I have a table like this
I need the result like this
Please do it in script
Go to Solution.
Previous(Previous(Amount)) as Expected
I have attached QV file, It should work fine in qs too
I don't understand your problem... what do you want in your "expected" column ?
Thanks for the answer. This is working fine
I was using Previous function, but this works for previous only. I was looking for parameters in Previous then also not working. But you used nested previous and that worked.
Thanks a lot.