Also, you need to follow the instructions. You have to shake the can for X/minutes. First upside down, the right side up, then pump etc. If you just spray without the prep the clear wont work. I forget how long, but you need to shake for a rather long time.
Bubbles or fish eyes are from oils. Crappy clear is either from not prepping the can properly, lots of moisture in the air or defective can. When you push the plug at the bottom of the can you are puncturing an agent. You need to use the entire can right away to have consistent results. If you "save for later" it wont work properly.