How to show data in single column by concatenating multiple rows

[sushil353]

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]

same thing you can take in pivot chart

it will show as you want

[lironbaram · Accepted solution]

hei check the attach file

[forte]

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]

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

Regards,

[swarup_malli]

Hello,

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

Thnx

SM