I need help with converting units of measure. I need the ability to see the measures in litres or cases.
Currently, all my measures are coming into Qlikview with the hectolitre measurement. It is easy for me to change all of it to litres because it is a 1 to 1 relationship between litres and hectolitres. However, I have different conversion to change it into cases because each package has a different conversion.
I have a table that gives me the conversion for each product in liters and cases. What is the best way to convert this or do this so that I have the ability to change the coming numbers from hectolitres to cases or liters.