
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Vizlib table is not showing the new line
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
Raghu
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
You shoud replace chr(10) with <br> and select an HTML representation for the measure

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
,' ')
Raghu


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it should be
if(count({<Day={'Mon'}>}EventDate)>0,
Date(only({<Day={'Mon'}>}EventDate),'DD') & '<br><br>' & only({<Day={'Mon'}>}EVENT)
,' ')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Lironbaram,
Thank you again for your response.
Sorry no luck.
it is showing as it is, please refer Tuesday column in below screenshot.
Raghu


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you need to check this box

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Raghu

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Lironbaram,
the ToolTip issue is also solved, I have enabled the tooltip for each column, now the ToolTip is showing correctly.
Thank you.
Raghu

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi where can we see this option in qliksense vizlib table.Please guide me
