Discussion Board for collaboration on QlikView Scripting.
Between Two fields how to do Concatenate in Script?
anybody Could give the solution?
Field1 & '-' & Field2
Field1 &'-'& Field2 as NewField
this will concatenate with - .
Same Thing i given but its not working
use autonumberhash function to make concatenate field with unique integer
like below used in both table
autonumberhash128(Field1,Field2) as Key
Hi,Try concatenating the fields in resident table..
These two fields are diff. table fields
I believe this could worked Field1 & '-' & Field2
See the load script
Load First,Last, First & '-' & Last as FirstnLast;
Load * Inline
By this model you concatenate the fields in the front end in any chart
Zone & '-' & Product
If you want to do that in any script then two tables are in one table then you are able to do that.
It Works Thanks for Suggession,
but i need exact out put
I have Fields like Organization, Zone then i want to concatenate these fields given below
i given like this Organization &' '& Zone as Organization
But My OutPut is like below
Greater India SAN+KEL,
Greater India VIDEOCON
i used if condition also but not show exact out put