Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Srinivas
Creator
Creator

Subtract quantity values based on transaction type

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

Labels (3)
4 Replies
shiveshsingh
Master
Master

May be like this?

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

Srinivas
Creator
Creator
Author

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

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

Vengatesh
Partner
Partner

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).

You Know What To Do.