LOV in Webi Cell formula

[former_member402770]

Hi Experts,

May i know the webi formula to display all list of values in an cell separated by semicolon.

Please see attached my expected results for Car Makers Object.

Many Thanks,

Dinya.

[jyothirmayee_s · Accepted solution]

Hi,

How does your data looks like.

May Car: 53445 has same LOTUS F with different location or dates.

Check the rows by selecting just that Car maker and Type.

Post a screen shot if possible.

Thanks,

Jothi

[mhmohammed]

It's better to create the logic in the Universe, try the below blog.
https://irfansworld.wordpress.com/2011/02/18/how-to-display-a-database-column-values-in-a-single-cel...

[jyothirmayee_s]

Hi,

How does your formula looks like?.

Thanks

Jothi

[former_member402770]

Jothi - Reportfilter([Car Makers]) displays LOV like below:

Porche; Lotus; LOTUS Fin; Apache; ..

Above LOV displays Lotus; LOTUS Fin two times for same Car Makers Id:53445

Thanks,

Dinya

[jyothirmayee_s]

Hi,

There are so many solutions on community. Here are couple of ways to get it.

http://bi.srivatsakr.com/2011/08/converting-rows-into-single-cell-comma.html

http://www.djames.net/BIBlog_Entries/How-to-get-multiple-values-into-one-cell

Thanks,

Jothi

[former_member402770]

Hi Jyothi,

I tried this logic applied at an single cell to display all Car Makers Objects LOV which is placed at my header section.

It throwed #MULTIVALUE error.

Thanks,

Dinya