Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Display Column values to row in Straight table

Hi I have data like

TeamDept

Aab IT

Other
Aab IT

IT

Ssms

Normal

AbbmsNone

here when I select  filter Team(Aab IT) in my straight table it is showing Other and IT in two rows, But I want to show it in a single row

like 'Other;IT'.

how can I show it

Please help me.

1 Solution

Accepted Solutions
awhitfield
Partner
Partner

I presume your expression I currently "dept", in which case, change it to Concat(Dept,';')

Andy

View solution in original post

2 Replies
awhitfield
Partner
Partner

I presume your expression I currently "dept", in which case, change it to Concat(Dept,';')

Andy

View solution in original post

sunny_talwar

Use Team as dimension and Concat(Dept, ';') as expression