This content has been marked as final. Show 2 replies
I am new in Qlik Sense, and I am confused for a problem as below.
for exapple, I have one table [purchase orders].
|Purchase Order No||Price||Quantity||Date||Amount||Material No||Company||Vendor No|
Now, I need to calculate as the rules below.
[Average Price in last year] = [total Amount in last year] / [total Quantity in last year]
[Saving Amount in this year] = [Price in this year] * [Quantity in this year] - [Average Price in last year] * [Quantity in this year]
And then, I will have make a virtualization for this [Saving Amount in this year] to drill down by Compay / Plant / Department / ... so on.
So, is there anyone who knows how to make it? It really takes a lot of time for me to study.
Thank you in advance.