Data representation not working correctly in table

[ashmitp869]

Hi there,

Please kindly assist to get the below table format in qlikview.

I have saved the Admin Contact like Name,Email id but I need to show it like

Admin Contact

Name

Email

My data looks like below- Coming in one line - Name,Email

[AshutoshBhumkar]

Hi @ashmitp869 ,

Not sure about Qlikview, but line break is not possible due to responsive nature.

But you can use below expression to identify and tag Name and Email.

e.g 

Facility, Admin Contact
A, AD1 dfwe@df.com
B, AD2 qqedw@efe.com

Will be like

Backend expression : If(Len(SubField("Admin Contact",' ',1))>0,'Name'&'-'&SubField("Admin Contact",' ',1)&','&'Email'&'-'&SubField("Admin Contact",' ',2)) as Name;

[NitinK7 · Accepted solution]

1. first you have to create calculate dimension

2. Go to presentation tab and select tick mark for 'wrap cell text box'

output

[AshutoshBhumkar]

Ok. Great ! 🙂