topic Re: MATCH,REPLACE,PEEK in QlikView

MATCH,REPLACE,PEEK

Thu, 25 Jun 2015 07:02:36 GMT

Hi,

My Excel data:

divisionname value

$'North region','Southregion' "nort d","south d"

'east r','west r' "e","w"

Qlikview script:

tab1:

LOAD replace(divisionname,'$','') as division1,
value
FROM

(biff, embedded labels, table is Sheet3$);
Let v1= Peek('division1', 0, 'tab1');

tab2:
load
[division1] as [divin1],
[value]
Resident tab1
where Match([division1],$(v1));

exit script;

Problem:

i pulled [divin1] in qlikview it must show 'North region','Southregion' but it is not showing.

$(v1) has this value.

pls help me where iam going wrong.

PFA qvw.

Re: MATCH,REPLACE,PEEK

jagan — Thu, 25 Jun 2015 08:11:48 GMT

Hi,

The issue with the single quote in the divisionname, try like this

tab1:

LOAD replace(replace(divisionname,'$',''), chr(39), '') as Temp,

replace(divisionname,'$','') as division1,
FROM

(biff, embedded labels, table is Sheet3$);
Let v1= Peek('division1', 0, 'tab1');

tab2:
load
[division1] as [divin1],
[value]
Resident tab1
where Match([Temp], '$(v1)');

Re: MATCH,REPLACE,PEEK

jsingh71 — Thu, 25 Jun 2015 08:36:30 GMT

Hi Prudhavi,

Use place your variable name inside the ' ' like below:

tab2:
load
[division1] as [divin1],
[value]
Resident tab1
where Match([division1],'$(v1)');

exit script;

It will work fine. See attached qvw.

Re: MATCH,REPLACE,PEEK

Thu, 25 Jun 2015 09:24:27 GMT

both of ur above metods did not work

Re: MATCH,REPLACE,PEEK

jagan — Thu, 25 Jun 2015 09:26:55 GMT

Hi,

Attach the sample file, then it would be easier.

Regards,

jagan.

Re: MATCH,REPLACE,PEEK

jsingh71 — Thu, 25 Jun 2015 09:59:45 GMT

Did you checked the attached qvw??

Re: MATCH,REPLACE,PEEK

Thu, 25 Jun 2015 10:31:30 GMT

i have already attached qvw

and may i know wat chr(39) will do?

Re: MATCH,REPLACE,PEEK

Thu, 25 Jun 2015 11:37:12 GMT

yeah i checked ur attachment.

tell me how '$(v1)' gave u anser?

$(v1) it self means value....placing in quotes must give error bt it wrked fr u ....

moreover i loaded data frm excel ....

when i loaded frm inline it wrked without placing in quotes.

if i place in quotes it is giving error

Re: MATCH,REPLACE,PEEK

Vikash — Sun, 20 Jun 2021 04:13:52 GMT

Hi,

Have you tried using Mixmatch() instead of Match()?