Discussion Board for collaboration on QlikView Scripting.
How to merge two columns with pivot table
Go to Solution.
Merge them how?
TRRP - zone
TRRP - region
TRRP - bdd
You can use below mentioned syntax to achieve your task.
zone & ', ' & region as Location
good morning ,YES sunny : D
You can do it in the script like srivastava.sarvesh pointed out by combing the two fields into one
Field1 & ' - ' & Field2 as Field_New
or you can use a calculated dimension like this and remove the individual dimensions
Field1 & ' - ' & Field2
sunny The table header does not change it is the label of the expression
Is this a straight table or pivot table?
I think you did not understand me