topic string to integer? in QlikView

string to integer?

Thu, 14 Jul 2011 20:18:59 GMT

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?

string to integer?

rbecher — Thu, 14 Jul 2011 20:24:45 GMT

Hi,

this should help:

data:

LOAD * INLINE [

3123MB

10GB

1400MB

12GB

];

result:

load if(right(F1,2)='MB', Num#(Mid(F1, 1, Len(F1)-2))/1024, Num#(Mid(F1, 1, Len(F1)-2))) as [space used]

Resident data;

- Ralf

string to integer?

Thu, 14 Jul 2011 20:53:38 GMT

Hi Ralf,

So i was hoping to change this in the expressions column of the graph. How should i enter this in the IF statement?

This is what i am working with right now:

if (wildmatch (space_used = '*MB')>0), space_used * (1/1024), space_used)

so this says that is you find MB then divide by 1024 else display as it is.

string to integer?

Thu, 14 Jul 2011 22:05:34 GMT

even this doesnt work: if(wildmatch(gp_rss_ram,'*M')>0, (Len(gp_rss_ram)-2)*(1/1024),gp_rss_ram)

Re: string to integer?

rwunderlich — Thu, 14 Jul 2011 22:46:22 GMT

How about:

=alt(num#(F1, '0MB')/1024

,num#(F1, '0GB')+0

, F1)

-Rob

http://robwunderlich.com

string to integer?

Fri, 15 Jul 2011 15:31:05 GMT

This worked: if(wildmatch(gp_rss_ram,'*M')>0,num#(gp_rss_ram, '#M')/1024,num#(gp_rss_ram,'#G'))