Discussion board where members can get started with QlikView.
I want to have an object where three fields will be concatenated and separated by '|' symbol. After selecting this it’s corresponding will be displayed in a separate chart.
Suppose there are 3 fields Empname, EmpId, sal. I want these three fields will be concatenated separating by “|” symbol. The composite field values will be used to copy and paste to SP site.
Thanks In Advance
Go to Solution.
Try to write like in loadscript you can use it in the front end also
Empname&'|'&EmpId&'|'&sal as NewField
The following can be done in the script or the chart
[field 1] & '|' & [field 2] & '|' & [field 3]
you can use in script to define a new field
Empname & '|' & EmoId & '|' & sal as NewField
You can do the same with a variable.
Depends on what you need in the separate chart. Can you be more specific?
Thank you all..