Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

concatenate the information in a columns or merge the columns data

Hi all,

It is possible to display in qlikview a table like this:

     

IDDescriptionOrderDateEndcomment
1bla bla bla12/10/201713/10/2017this is the last comment
1bla bla bla12/10/201713/10/2017this is the first comment
2abc abc abc13/10/201713/10/2017this is the last comment
2abc abc abc13/10/201713/10/2017this is the middle comment
2abc abc abc13/10/201713/10/2017this is the first comment

Into this format:

     

IDDescriptionOrderDateEndcomment
1bla bla bla12/10/201713/10/2017this is the last comment
this is the first comment
2abc abc abc13/10/201713/10/2017this is the last comment
this is the middle comment
this is the fist comment

As you can see that the information is duplicated in the first 4 column and only in the last column we got different data.

created and example

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Use a Pivot Table, with 1 as expression

0li5a3a
Creator III
Creator III
Author

Is not a way to don't display the 1 into the column?

0li5a3a
Creator III
Creator III
Author

And when I export the files to excel  nothing is changed. I tried to avoid the people to do manual manipulation.

madhumitha
Creator
Creator

Hi Constantin,

Qlikview does not hold formatting while exporting to excel.

Macros might help on formatting the exported data.

Thanks

0li5a3a
Creator III
Creator III
Author

Thanks to let me know. In this case I can't do it...

alexandros17
Partner - Champion III
Partner - Champion III

Try This,

I used a trick ... color 1 with blank

0li5a3a
Creator III
Creator III
Author

Thanks Alessandro.

I still need to find a way to keep the format the same like in qlikview and export it to excel:)