Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Karim_Khan
Contributor III

how to concatenate two coulmn value into one

Hi Team,

how to concatenate two column value into one single column.

I wanted to create the logic in which if I select the Programme Name then it should pick the Program name along with its Entry Pages.

1 Solution

Accepted Solutions
ganeshreddy
Contributor III

Re: how to concatenate two coulmn value into one

Hi karim,

use new dimension like below

Load

[Programme Name],

[Entry Pages],

[Programme Name]&' '&[Entry Pages] as Combination,

.......


FROM ......;



use above combination field when its required as combination.



Regards,

Ganesh

3 Replies
ganeshreddy
Contributor III

Re: how to concatenate two coulmn value into one

Hi karim,

use new dimension like below

Load

[Programme Name],

[Entry Pages],

[Programme Name]&' '&[Entry Pages] as Combination,

.......


FROM ......;



use above combination field when its required as combination.



Regards,

Ganesh

Highlighted
gautik92
Valued Contributor III

Re: how to concatenate two coulmn value into one

create a key

ProgrammeName &'|'&  EntryPages as  %Key

Karim_Khan
Contributor III

Re: how to concatenate two coulmn value into one

Hi,

    I wanted to get the sum of visits on the selection of current programme but its not working by applying below expression

=sum({$<[(v0) Program Name]={Combination}>}Visits)