topic Re: Data representation not working correctly in table in QlikView

Data representation not working correctly in table

ashmitp869 — Wed, 01 Sep 2021 06:19:23 GMT

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

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

Re: Data representation not working correctly in table

AshutoshBhumkar — Wed, 01 Sep 2021 07:05:24 GMT

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;

Re: Data representation not working correctly in table

NitinK7 — Wed, 01 Sep 2021 10:29:09 GMT

1. first you have to create calculate dimension

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

output

Re: Data representation not working correctly in table

AshutoshBhumkar — Wed, 01 Sep 2021 11:09:59 GMT

Ok. Great ! 🙂