Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 ali_hijazi
		
			ali_hijazi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello
Check attached sample QVW (reduced)
I have a column called balance_quantity_puom
I see it that it has the value of 5
My expression is as follows:
div($(vInventory_Qty_Balance),Only({<document_status,trx_type="inventory_balances"},trx_date=$(=max(trx_date))}>}product_unit_per_pack))
$(vInventory_Qty_Balance) gives 5
and 
Only({<document_status,trx_type="inventory_balances"},trx_date=$(=max(trx_date))}>}product_unit_per_pack) gives 1
why I'm getting 4 instead of 5?
is this a bug in QlikView????
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Seems like something related to rounding... this works
=div(
Round($(vInventory_Qty_Balance)),
Round(Only({<document_status,trx_type={"inventory_balances"},trx_date={$(=max(trx_date))}>}product_unit_per_pack))
)
 ali_hijazi
		
			ali_hijazi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		the thing is that I want to display in the table quantity as CASES \ EACH
for example:
if a product has 2 EA in a CASE and the Quantity is 13 EA then I should display 6\1 i.e. 6 cases and 1 EA
and sometimes the quantity is negative
13/2 is 6.5 so if I use round I will get 7 whereas I want the 6 cases \ 1
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I am not rounding the resulting number
Round(div(13, 2))
I am rounding the numbers before we use div
div(Round(13), Round(2))
I don't think you will get 7 for the second one... have you tried it unsuccessfully?
