topic Re: Vizlib table is not showing the new line in App Development

Vizlib table is not showing the new line

sarsukanth — Fri, 23 Jul 2021 07:14:00 GMT

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

Re: Vizlib table is not showing the new line

lironbaram — Fri, 23 Jul 2021 12:36:32 GMT

Hi ,

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

Re: Vizlib table is not showing the new line

sarsukanth — Fri, 23 Jul 2021 15:58:17 GMT

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 , but it is giving this error(Error in Expression : ')' expected), so please tell me the correct way of using the

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

Re: Vizlib table is not showing the new line

lironbaram — Mon, 26 Jul 2021 12:00:22 GMT

it should be

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

Re: Vizlib table is not showing the new line

sarsukanth — Mon, 26 Jul 2021 15:14:45 GMT

Hi Lironbaram,

Thank you again for your response.

Sorry no luck.

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

Re: Vizlib table is not showing the new line

lironbaram — Tue, 27 Jul 2021 06:04:07 GMT

Hi,
you need to check this box

Re: Vizlib table is not showing the new line

sarsukanth — Tue, 27 Jul 2021 06:13:31 GMT

Hi Lironbaram,

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

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

Thank you again.

Re: Vizlib table is not showing the new line

sarsukanth — Tue, 27 Jul 2021 06:18:14 GMT

Hi Lironbaram,

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

Thank you.

Re: Vizlib table is not showing the new line

felcar2013 — Mon, 11 Jul 2022 19:03:50 GMT

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

Re: Vizlib table is not showing the new line

Lucky1 — Thu, 08 Jun 2023 14:05:29 GMT

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