topic Merge two columns in QlikView

Merge two columns

souadouert — Wed, 05 Apr 2017 09:18:50 GMT

Good Morning

How to merge two columns with pivot table

Re: Merge two columns

sunny_talwar — Wed, 05 Apr 2017 09:37:07 GMT

Merge them how?

Re: Merge two columns

sunny_talwar — Wed, 05 Apr 2017 09:37:41 GMT

Like this?

TRRP - zone

TRRP - region

TRRP - bdd

Re: Merge two columns

sarvesh — Wed, 05 Apr 2017 09:39:31 GMT

Hi..Souad,

You can use below mentioned syntax to achieve your task.

zone & ', ' & region as Location

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 09:43:35 GMT

good morning ,YES sunny : D

Re: Merge two columns

sunny_talwar — Wed, 05 Apr 2017 09:46:26 GMT

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

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 10:04:46 GMT

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

Re: Merge two columns

sunny_talwar — Wed, 05 Apr 2017 10:08:04 GMT

Is this a straight table or pivot table?

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 10:09:50 GMT

pivot table

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 10:18:12 GMT

hi SARVESH

I think you did not understand me

Re: Merge two columns

sarvesh — Wed, 05 Apr 2017 10:25:59 GMT

As i understand you don't want to change the column name..right ?

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 10:32:30 GMT

I want to view the two columns zone and region under a header named trpp

Re: Merge two columns

sarvesh — Wed, 05 Apr 2017 10:38:31 GMT

For this you have to add row.

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 10:46:28 GMT

y mean calculated dimension ?

Re: Merge two columns

sarvesh — Wed, 05 Apr 2017 10:51:50 GMT

if you want headers "zone and region" under header "trpp" then yes, however if you want only values of "zone and region" under header "trpp" then write the syntax:

zone & ', ' & region as trpp

Re: Merge two columns

sunny_talwar — Wed, 05 Apr 2017 10:58:18 GMT

and what about the rest of the three columns?

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 12:24:10 GMT

I apologize I do not understand anything i have not the ability to use AS in expression of calculated dimension, and zone ans region are two label for two expression

region: ([Effort brut]/[Objectif 2017])/MONTHNUM

zone:([Effort brut]/round(sum({< REGION,REGION = {$(=(REGION))}>}[OBJ_CONQUETE.TOTAL])/100*60))/MONTHNUM

Re: Merge two columns

sarvesh — Wed, 05 Apr 2017 12:35:10 GMT

Now i'm confused ha ha ha

Could you share desired format of the table, if you can draw manually.

Re: Merge two columns

souadouert — Wed, 05 Apr 2017 12:53:37 GMT

Re: Merge two columns

sunny_talwar — Wed, 05 Apr 2017 12:56:42 GMT

Like this?