Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

How to show data in single column by concatenating multiple rows

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:

F2.JPG

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

F1.JPG

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

Thanks

Sushil Kumar

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

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

hei check the attach file

5 Replies
chauhans85
Esteemed Contributor

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

same thing you can take in pivot chart

it will show as you want

lironbaram
Honored Contributor II

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

hei check the attach file

forte
New Contributor III

How to show data in single column by concatenating multiple rows

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
New Contributor III

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

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

Regards,

swarup_malli
Valued Contributor

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

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

Community Browser