Vizlib table is not showing the new line

[sarsukanth]

Hi All,

Greetings for the day.

I have used a Vizlib table to show a calendar view, almost all done but only below one issue occurring.

I have used chr(10) to give new line between Day and Events of that particular day, but the table is showing both in one line only

but it is showing in a new line when the mouse hovers on the same

so someone please help me to give some idea, so the appearance of the table also show new line.

PFB the screenshot for better understanding of the issue.

Thank you,

Raghu

[lironbaram]

Hi , 

You shoud replace chr(10) with <br> and select an HTML representation for the measure

[sarsukanth]

Hi Lironbaran,

Thank you for your quick response.

I have used the below formula in table for Monday column

if(count({<Day={'Mon'}>}EventDate)>0,
Date(only({<Day={'Mon'}>}EventDate),'DD') & chr(10) & chr(10) & only({<Day={'Mon'}>}EVENT)
,' ')

as you said I am trying to replace the chr(10) with <br>, but it is giving this error(Error in Expression : ')' expected), so please tell me the correct way of using the <br>

if(count({<Day={'Mon'}>}EventDate)>0,
Date(only({<Day={'Mon'}>}EventDate),'DD') & <br> & <br> & only({<Day={'Mon'}>}EVENT)
,' ')

[lironbaram]

it should be 

if(count({<Day={'Mon'}>}EventDate)>0,
Date(only({<Day={'Mon'}>}EventDate),'DD') & '<br><br>' & only({<Day={'Mon'}>}EVENT)
,' ')

[sarsukanth]

Hi Lironbaram,

Thank you again for your response.

Sorry no luck.

it is showing as it is, please refer Tuesday column in below screenshot.

[lironbaram · Accepted solution]

Hi, 
you need to check this box 

[sarsukanth]

Hi Lironbaram,

Thank you very much for your support and all your responses, now it is working fine.

One small observation, the <br><br> is showing in the tooltip now, anyway its ok.

Thank you again.

[sarsukanth]

Hi Lironbaram,

the ToolTip issue is also solved, I have enabled the tooltip for each column, now the ToolTip is showing correctly.

Thank you.

[felcar2013]

hi Raghu

if you have more than 2 events on one day, how did you display the outcome in one cell?

Ex.: If you want to display Event_1 and Event_2 in the cell for the day 2nd of August 2021

Event | Date | other data

Event_1 | 02.08.2021 | xxx

Event_2 | 02.08.2021 | xxx

[Lucky1]

Hi where can we see this option in qliksense vizlib table.Please guide me