topic Re: joining two values in QlikView

joining two values

Sun, 25 May 2014 07:07:44 GMT

as i shown in the below image what i have highlighted in red is the same person who has two names in the DB i want to combine these two record as 1 n show the result how can i do this??

thank you in advance

Re: joining two values

PrashantSangle — Sun, 25 May 2014 07:12:51 GMT

Hi,

If SDExcuetvieAssigne is your dimension

then write in your deimension tab

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',SDExcuetiveAssigne)

Regards

Re: joining two values

Sun, 25 May 2014 07:21:48 GMT

can i add more names to the same equation ?? in the image can u see there is a norther name as "kaushal" with two surnames i want to combine that to so is it possible to attach that to the same wild-match??

Re: joining two values

ashfaq_haseeb — Sun, 25 May 2014 07:23:28 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: joining two values

ashfaq_haseeb — Sun, 25 May 2014 07:24:45 GMT

Hi,

yes you can use multiple ifs.

Regards

ASHFAQ

Re: joining two values

PrashantSangle — Sun, 25 May 2014 07:25:52 GMT

Hi,

You can not implemented in same wildmatch but,

You can go with nested if else

like,

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',wildmatch(SDExcuetiveAssigne,'Kaushal*'),'Kaushal',SDExcuetiveAssigne)

Regards,

Re: joining two values

Sun, 25 May 2014 07:38:39 GMT

i am getting an error in this

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',wildmatch(SDExcuetiveAssigne,'Kaushal*'), <-- (this is underlined in red)

'Kaushal',SDExcuetiveAssigne)

Re: joining two values

PrashantSangle — Sun, 25 May 2014 07:41:03 GMT

Hi,

Write it in if Condition like

if(wildmatch(SDExcuetiveAssigne,'chathura Munasingha','chathura Munasinghe'),'chathura Munasingha',if(wildmatch(SDExcuetiveAssigne,'Kaushal*'),'Kaushal',SDExcuetiveAssigne))

Regards,

Re: joining two values

Sun, 25 May 2014 07:41:09 GMT

a if was miss there Right??

Re: joining two values

Sun, 25 May 2014 07:47:05 GMT

thank you soooo much it works perfectly

Re: joining two values

PrashantSangle — Sun, 25 May 2014 07:48:53 GMT

Welcome.

Regards,

Re: joining two values

Sun, 25 May 2014 07:56:02 GMT

thank you 4 your help to

Re: joining two values

maxgro — Sun, 25 May 2014 07:58:12 GMT

nested if

Temp:

load * inline

[

SDExecutives,Sale

Rohan Fernando,803

Dasun Wedaasinghe,285

Chathura Munasinghe,221

Chathura Munasingha,172

Chathura Munasingho,172

Diyath wickramaratne,128

Nuwan Shaweendra,103

Kaushal Jayabahu,93

Kaushal Premawansha,186

];

Main:

load

if(WildMatch(SDExecutives, '*chathura*'), 'Chathura Munasinghe',

if(WildMatch(SDExecutives, '*kaushal*'), 'Kaushal Jayabahu',

if(WildMatch(SDExecutives, '*not?exists*'), 'not exists',

SDExecutives))) as SDExecutives_New

Resident Temp;

drop table Temp;

another one

Main:

load

pick( WildMatch(SDExecutives, '*chathura*', '*kaushal*', '*' ),

'Chathura Munasinghe', 'Kaushal Jayabahu', SDExecutives ) as SDExecutives_New

Resident Temp;

drop table Temp;

from online help

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.