Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hei check the attach file
same thing you can take in pivot chart
it will show as you want
hei check the attach file
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
Thanks for both the question and the answers. This was very helpful for me for a similar case.
Regards,
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