4 Replies Latest reply: Sep 14, 2011 6:59 AM by Stefan Wühl RSS

    using the num# function in a textbox

    Aissam Boumejjane

      Hi Guys,


      I'm quite new to qlikview. I have a expression in a textbox that give me the results. Unfortunately it's not in percentage.

      How can I change this to 37% in stead of 37,71186xxxxxxx

      I think I need to use the Num# function, I just don't know how to add it in my expression:


      =Num#(Count({<CustomClearance={OnTime}, Destination={BJS}>} Destination) / Count({<Destination={BJS}>} Destination)) * 100


      text object.bmp


      Hope some can help me out!