topic Re: How to show data in single column by concatenating multiple rows in QlikView

How to show data in single column by concatenating multiple rows

sushil353 — Mon, 23 Jan 2012 07:44:41 GMT

Hi All,

In have a table in which there is information in multiple rows.. how can i concat all information in one row with some modification.

for example i have a table given below:

and i want to show data in a separate table like in table given below:

How this can be achieved in Qlikview...? please find the attached application ..

Thanks

Sushil Kumar

SunilChauhan — Mon, 23 Jan 2012 08:04:36 GMT

same thing you can take in pivot chart

it will show as you want

lironbaram — Mon, 23 Jan 2012 08:09:36 GMT

hei check the attach file

forte — Mon, 23 Jan 2012 08:09:41 GMT

Hi Sushil :

You can try using the following expression :

'Sequence File : ' & maxstring({<T_TYPE = {"RUNTIME_ERROR_SEQUENCE_FILE"}>} T_MEASUREMENT) & chr(13) & chr(10) &

'Sequence : ' & maxstring({<T_TYPE = {"RUNTIME_ERROR_SEQUENCE"}>} T_MEASUREMENT)& chr(13) & chr(10) &

'Step : ' & maxstring({<T_TYPE = {"RUNTIME_ERROR_STEP"}>} T_MEASUREMENT)& chr(13) & chr(10) &

'Code : ' & maxstring({<T_TYPE = {"RUNTIME_ERROR_CODE"}>} T_MEASUREMENT)

Just use it on a Simple Table or a Pivot Table and remember to check "Divide Cell Text" with a proper number of lines.

Hope it helps,

Regards

murozel76 — Thu, 16 Aug 2012 09:35:03 GMT

Thanks for both the question and the answers. This was very helpful for me for a similar case.

Regards,

swarup_malli — Wed, 27 Mar 2013 19:36:02 GMT

Hello,

I have a similar requirement.its a little complex. The thread can be found at http://community.qlik.com/message/327257#327257

Thnx