Discussion board where members can get started with QlikView.
I have a field 'space used'. This is either in MB or GB.
data looks like this:
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?
Go to Solution.
this should help:
LOAD * INLINE [
load if(right(F1,2)='MB', Num#(Mid(F1, 1, Len(F1)-2))/1024, Num#(Mid(F1, 1, Len(F1)-2))) as [space used]
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.
even this doesnt work: if(wildmatch(gp_rss_ram,'*M')>0, (Len(gp_rss_ram)-2)*(1/1024),gp_rss_ram)
This worked: if(wildmatch(gp_rss_ram,'*M')>0,num#(gp_rss_ram, '#M')/1024,num#(gp_rss_ram,'#G'))