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!

       

      Cheers

       

      iSam