topic Re: Need Help in Concat Function in QlikView

Need Help in Concat Function

Anonymous — Thu, 14 Aug 2014 21:00:58 GMT

Hello ! pls. help me compose formula in concatinating items

Fruits Description Desired New field

Apple red red/sweet/round

Apple sweet red/sweet/round

Apple round red/sweet/round

Banana yellow yellow/long/sweet/fresh

Banana long yellow/long/sweet/fresh

Banana sweet yellow/long/sweet/fresh

Banana fresh yellow/long/sweet/fresh

Orange sour sour

I'd like to concat all the item in description field of a certail Fruit...pls. see my desired outpu in red text.

Tks.

Re: Need Help in Concat Function

Thu, 14 Aug 2014 21:07:45 GMT

Check the attached QVW

Re: Need Help in Concat Function

Thu, 14 Aug 2014 21:09:04 GMT

Sorry, I took the liberty of assuming you only wanted to show the three rows in your table haha. Hope that works for you!

Re: Need Help in Concat Function

Thu, 14 Aug 2014 21:14:11 GMT

Attached with answer. Used Robert's file and made some changes to it. Calculations are done in the script(back-end)

Thanks

Re: Need Help in Concat Function

maxgro — Thu, 14 Aug 2014 21:24:04 GMT

you can make a chart with

dimensions

- Fruits

- Description

expression

- concat(TOTAL <Fruits> Description, '/')

Re: Need Help in Concat Function

MarcoWedel — Thu, 14 Aug 2014 21:31:12 GMT

Hi,

one example:

tabFruits:
LOAD * INLINE [
    Fruits, Description
    Apple, red
    Apple, sweet
    Apple, round
    Banana, yellow
    Banana, long
    Banana, sweet
    Banana, fresh
    Orange, sour
];

tabFruitSummary:
LOAD Distinct
  Fruits,
  Concat(Description, '/', RecNo()) as [Desired New field]
Resident tabFruits
Group By Fruits;

hope this helps

regards

Marco

Re: Need Help in Concat Function

Anonymous — Thu, 14 Aug 2014 22:14:47 GMT

Thank you, Ajay...it worked.