My Query is that i want to view net purchase return as you can view in uploaded Qlik view file Tristar.
Here Net Puchase Return = Purchase Return - Void Purchase Return
But here i am getting the Void purchase return also
I want to view only Net Puchase Return Bills.
The Primary key is TrnType and TrnCtrlno
In the Void Bill it is BackRefTrnType and BackRefCtrlNo.
The same problem is for other transaction also
The QlikView File is present on the Web Server with Link
http://www.4shared.com/file/128317461/b223a122/Tristar.html
pls help me out ..................
Ashish Michael