5 Replies Latest reply: Jul 15, 2011 11:31 AM by ggoyal_123 RSS

    string to integer?

      Hi,

       

      I have a field 'space used'. This is either in MB or GB.

       

      data looks like this:

       

      3123MB

      10GB

      1400MB

      12GB

       

      I want to display the entire column in terms of GB. So i have to convert my MB data to GB. Just dividing by 1024 doesnt work since Qlikview considers this to be a string.

       

      How can i do this?