topic Re: Subtract quantity values based on transaction type in QlikView

Subtract quantity values based on transaction type

Srinivas — Sat, 16 Nov 2024 03:47:53 GMT

Hi Team,

I want to subtract the quantity values based on different type transaction, in final Qty i want to see only positive values.

Actually logic is whatever total CR values minus DR Values for the same i did CR-DR as Qty , in that Qty columns have the negative values bot i don't want see the negative value.

Thanks,

Reddy

Re: Subtract quantity values based on transaction type

shiveshsingh — Mon, 22 Apr 2019 16:53:30 GMT

May be like this?

If ( CR-DR>=0,CR-DR) as Quantity

Re: Subtract quantity values based on transaction type

Srinivas — Tue, 23 Apr 2019 00:46:00 GMT

If we write this expression we are getting the wrong out put.

Re: Subtract quantity values based on transaction type

shiveshsingh — Tue, 23 Apr 2019 10:21:53 GMT

Okay, please let me know the expected output from your attached excel file and also the formula that you are using.

Re: Subtract quantity values based on transaction type

Vengatesh — Tue, 23 Apr 2019 10:43:14 GMT

What you are trying to do here Subract? or Difference Between?,

If you want to calculate the difference you can use this If(CR>DR ,CR-DR, DR-CR).