Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Go through this thread Concat function | Qlik Community
You can use Concat Function to achieve the same.
Vikas
Can you paste here a sample output of the above data itself?
Plz check the screenshot.Its actually a hierarchy from cognos.I need to implement it in Qlik.