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:
if(Nachname & ' ' & Vorname = name,1,0) as Flag;
LOAD * INLINE [
Nachname, Vorname, name
Hans, Fritz, Hans Fritz
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
or maybe have a look at
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.
Name as NameKey,
Your tables would then be joined by NameKey.