Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

Merge two columns

Good Morning

How to merge two columns with pivot table

TAB.PNG

1 Solution

Accepted Solutions
MVP
MVP

Re: Merge two columns

Like this?

Capture.PNG

21 Replies
MVP
MVP

Re: Merge two columns

Merge them how?

MVP
MVP

Re: Merge two columns

Like this?

TRRP - zone

TRRP - region

TRRP - bdd

srivastava_sarv
Contributor III

Re: Merge two columns

Hi..Souad,


You can use below mentioned syntax to achieve your task.


zone & ', ' & region as Location

souadouert
Contributor III

Re: Merge two columns

good morning ,YES sunny : D

MVP
MVP

Re: Merge two columns

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

souadouert
Contributor III

Re: Merge two columns

sunny The table header does not change it is the label of the expression

merge.PNG

expPNG.PNG

MVP
MVP

Re: Merge two columns

Is this a straight table or pivot table?

souadouert
Contributor III

Re: Merge two columns

pivot table

souadouert
Contributor III

Re: Merge two columns

hi SARVESH

I think you did not understand me

merge.PNG

expPNG.PNG

Community Browser