topic Re: Connect data? in QlikView

Connect data?

Thu, 20 Feb 2014 08:51:41 GMT

Hi,

I am totally new to QV and would really appreciate som help.

I load QV with data only from excel. I have loaded two different documents but can not create a proper connection between them. In the both documents I have a column with customers. I have tried to name the columns the same name and then I get the connection but in the list of customers the same customers appers twice if they are in the both columns. It looks like the customers name is spelled the same way, but could it be this way if it not EXACTLY the same spelled or how can I manage this?

Thanks in advance!

/Lina

Re: Connect data?

MK_QSL — Thu, 20 Feb 2014 09:11:50 GMT

Can you let us know your script here?

Re: Connect data?

Thu, 20 Feb 2014 09:20:46 GMT

Can you attach the script and sample excel files ?

Re: Connect data?

MK_QSL — Thu, 20 Feb 2014 09:21:39 GMT

Looks Ok... is it possible to load your apps?

Re: Connect data?

MK_QSL — Thu, 20 Feb 2014 09:46:15 GMT

Please load your qvw file.

Re: Connect data?

Thu, 20 Feb 2014 09:47:33 GMT

Can you attach the qvw and excel files you are using?

Re: Connect data?

Thu, 20 Feb 2014 09:55:54 GMT

Dear all helpful people,

When I changed the names of the customer to exactly the same I got it to work! My problem is that I can not manually change the name of 1000 customers. Is it possible to match the data in two columns that are nearly the same as:

RADMANSO TRAILER AB

RADMANSO TRAILER AB -74953

Thank you so far!

/Lina

Re: Connect data?

MK_QSL — Thu, 20 Feb 2014 10:04:11 GMT

You wildmatch function.

Re: Connect data?

Thu, 20 Feb 2014 10:04:14 GMT

use if not Exists

Re: Connect data?

Thu, 20 Feb 2014 10:23:52 GMT

Sorry for being slow, bot can I "match" the customer in each column KundNy directly in the edit script with the wildmatch function?

Re: Connect data?

Thu, 20 Feb 2014 14:23:05 GMT

Hi Lina,

If i understood your problem, the problem lies in your data like below.

Think like Table1: KundNy data has "Lina ced" and Table2: KundNy data has "lina Ced". The name is same in both the tables but you are viewing it twice.

If it is the case use Capitalize() function in the script for both the tables.

Ex: Capitalize(KundNy)

Please let me know if it is not the case.

Re: Connect data?

Thu, 20 Feb 2014 15:45:28 GMT

Thank you for your input, you have almost got it right but it is not capitals that is tha problem, it is numbers. I have customer names that is:

"Lina Ced"

"Lina Ced -2423"

which is the same customer. Is there a function that can help me "erase the number and spaces"?

Thank you in advance.

Re: Connect data?

jpapador — Thu, 20 Feb 2014 15:49:07 GMT

You could try:

Trim(PurgeChar(FIELDNAME, '1234567890-')) as NewCustomerName

That will take out and numbers and the dash and also trim any leading or trailing spaces.

Re: Connect data?

Thu, 20 Feb 2014 15:55:58 GMT

Thanks, but I tried it in list box properties under the sheet expresion, but nothing happend. Should i write the expression somewhere else?

Re: Re: Connect data?

jpapador — Thu, 20 Feb 2014 16:00:17 GMT

Yes in the script. Please see attached for an example.

Re: Connect data?

Thu, 20 Feb 2014 16:05:40 GMT

Thank you so much!

Re: Connect data?

Thu, 20 Feb 2014 16:38:12 GMT

One last thing, your expression runs perfect, but my problem now is that the names of the customer is data from two excel columns. How do I get Name to be a "vector" and not just RAD AB and RAD AB -1215

Table1:

LOAD
        Name,
        Trim(PurgeChar(Name, '1234567890-')) as NewName
Inline [
       Name
       RAD AB

RAD AB -1215

];