creating a column out of present column - Qlik Community

imrasyed · ‎2018-06-15

Hi Experts,

TableA:

TerritoryNo,TerritoryName

1,AS

2,SD

3,ER

4,FG

5,ER

I want to create a seperate column with the consolidation of Territory No's 3,4,5

TableB:

1,AS

2,SD

'(3,4,5 Territories)',

How can we achieve this?

Appreciate your Help

vikasmahajan · ‎2018-06-15

Go through this thread Concat function | Qlik Community

You can use Concat Function to achieve the same.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

shanky1907 · ‎2018-06-15

Can you paste here a sample output of the above data itself?

imrasyed · ‎2018-06-15

Plz check the screenshot.Its actually a hierarchy from cognos.I need to implement it in Qlik.