topic Re: replace in QlikView

replace

Thu, 30 Oct 2014 09:00:06 GMT

how to replace the '<=x<' symbol with '-' function using replace function?

Re: replace

SunilChauhan — Thu, 30 Oct 2014 09:02:19 GMT

Replace(fieldName,'<=x<' ,'')

hope this helps

Re: replace

Kushal_Chawda — Thu, 30 Oct 2014 09:03:42 GMT

try like this

Replace('<=x<abcd','<=x<','-')

Re: replace

Thu, 30 Oct 2014 09:19:03 GMT

new:

LOAD Region,

Year,

Products,

Sales,

class

([Sales],30) as Salesrange

FROM

(biff, embedded labels, table is Sheet1$);

LOAD * , Replace(Salesrange,'<=x<' ,'-')

Resident new;

DROP Table new;

here replace function is not working y??

Re: replace

Colin-Albert — Thu, 30 Oct 2014 09:23:15 GMT

Try this

new:

LOAD Region,

Year,

Products,

Sales,

replace ( class(Sales,30) ,'<=x<' ,'-') as Salesrange

FROM

(biff, embedded labels, table is Sheet1$);

Re: replace

anbu1984 — Thu, 30 Oct 2014 09:23:33 GMT

Check if you have spaces in between string '<=x<' in your input

Can you provide sample data for which replace didn't work

Re: replace

Thu, 30 Oct 2014 09:24:31 GMT

Hi siva,

try this

new:

LOAD Region,

Year,

Products,

Sales,

class

([Sales],30) as Salesrange

FROM

(biff, embedded labels, table is Sheet1$);

LOAD * , Replace(Salesrange,'<=x<' ,'-') as Sales_Range

Resident new;

DROP Table new;

LOAD * , Replace( ([Sales],30),'<=x<' ,'-') as Sales_Range

Resident new;

Re: replace

Thu, 30 Oct 2014 09:34:48 GMT

hey, siva prasad

it's very simple.

replace(fieldname,'<=x<','-') as fieldname

cheers,

kunal bhattacharjee

Re: replace

SunilChauhan — Thu, 30 Oct 2014 09:47:10 GMT

Replace(trim(Salesrange),'<=x<' ,'-') as yourfieldname

Re: replace

SunilChauhan — Thu, 30 Oct 2014 09:57:42 GMT

or try to copy <=x< from you Salesrange in replace above

hope this helps

Re: replace

Thu, 30 Oct 2014 10:16:04 GMT

its not working

new:

LOAD Region,

Year,

Products,

Sales,

class

([Sales],30) as Salesrange

FROM

(biff, embedded labels, table is Sheet1$);

LOAD * , Replace(Salesrange,'<=x <' ,'-') as Sales_Range

Resident new;

DROP Table new;

Re: replace

MarcoWedel — Thu, 30 Oct 2014 11:06:27 GMT

Dual(Replace(Class(Sales,30),'<= x <','-'),Class(Sales,30)) as Salesrange

Re: replace

SunilChauhan — Thu, 30 Oct 2014 11:09:00 GMT

Replace(Salesrange,'<=x <' ,'-')

seems there is space in between x and <

use below

Replace(Salesrange,'<=x <' ,'-') as Sales_Range

Re: Re: replace

MarcoWedel — Thu, 30 Oct 2014 11:12:19 GMT

Hi,

replacing the '<= x <' string using replace() is only one thing, because doing so you will get just a string, not a dual value like the class function generates. i.e. you would have to implement sorting expressions in charts to get the right order of you class dimension.

To avoid this issue, one solution could be:

tabSales:
LOAD *,
    Dual(Replace(Class(Sales,30),'<= x <','-'),Class(Sales,30)) as Salesrange;
LOAD 'Region'&Ceil(Rand()*10) as Region,
    2000+Floor(Rand()*15) as Year,
    'Product'&Ceil(Rand()*10) as Products,
    Money(Round(Rand()*300,0.01)) as Sales
AutoGenerate 100;

hope this helps

regards

Marco

Re: replace

MarcoWedel — Fri, 31 Oct 2014 12:54:43 GMT

Hi,

did any of the proposed solutions answer your question?

regards

Marco

Re: replace

Sat, 01 Nov 2014 06:18:21 GMT

yes thank macro