topic Re: Why can't i compare these two ? in QlikView

Why can't i compare these two ?

Thu, 03 Dec 2015 14:38:17 GMT

Hey can somenoe help me pls, because i don't understand why

Re: Why can't i compare these two ?

swuehl — Thu, 03 Dec 2015 17:59:37 GMT

Hard to tell. Could you post some sample data?

Are you maybe missing a space between the single quotes? Or do you want to concatenate in other order:

Vorname & ' ' & Nachname

Or does your 'name' field is maybe called 'Name' in fact (Qv is case sensitive)?

Or does 'name' field contain another character instead of a simple space as separator?

edit: In general, can't see anything wrong:

LOAD *,

if(Nachname & ' ' & Vorname = name,1,0) as Flag;

LOAD * INLINE [

Nachname, Vorname, name

Hans, Fritz, Hans Fritz

];

Re: Why can't i compare these two ?

Thu, 03 Dec 2015 18:28:33 GMT

Hi Hans, I think that you lost a space between the name and the first name.

So, try this:

if(Nachname & ' ' & Vorname = name,1,0)

I hope that it help you,

Regards,

Agustín

Re: Why can't i compare these two ?

Fri, 04 Dec 2015 09:52:57 GMT

Hey swuehl, i forgot to say that the fields "vorname" and "nachname" come from another exel file than the field "name".

Is the Problem maybe that they don't see each other ?

Re: Why can't i compare these two ?

swuehl — Fri, 04 Dec 2015 14:36:11 GMT

That could indeed be an issue. How are the tables linked in your data model?

Re: Why can't i compare these two ?

simenkg — Fri, 04 Dec 2015 14:55:44 GMT

try to put trim() around vorname and nachname to make sure that noe extra spaces are present.

if(Trim(Nachname)&' '&Trim(Vorname) = Trim(name), 1 , 0)

Re: Why can't i compare these two ?

Tue, 08 Dec 2015 07:21:20 GMT

I thought i can just compare them over these attributes(name=nachname&vorname), they aren't really linked to each other.

If i need to link them before i can compare them, how do i make that?

Re: Why can't i compare these two ?

swuehl — Tue, 08 Dec 2015 23:41:44 GMT

How does your data model look like? You link tables by a common field name. If you are unsure how to do this, I would suggest that you do the free Qlik training courses you can access here

New to QlikView

or maybe have a look at

Video Link : 3483

Re: Why can't i compare these two ?

Wed, 09 Dec 2015 14:18:33 GMT

Without seeing your data, if you have "nachname" and "vorname" in one (first) table, and "name" in another (second), you could create a compound key in your first table, such as

Trim(nachname)&' '&Trim(vorname) As NameKey

and alias your name field in the second table e.g.

Load

Name,

Name as NameKey,

...

Your tables would then be joined by NameKey.