Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi ,
You shoud replace chr(10) with <br> and select an HTML representation for the measure
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)
,' ')
it should be
if(count({<Day={'Mon'}>}EventDate)>0,
Date(only({<Day={'Mon'}>}EventDate),'DD') & '<br><br>' & only({<Day={'Mon'}>}EVENT)
,' ')
Hi Lironbaram,
Thank you again for your response.
Sorry no luck.
it is showing as it is, please refer Tuesday column in below screenshot.
Hi,
you need to check this box
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.
Hi Lironbaram,
the ToolTip issue is also solved, I have enabled the tooltip for each column, now the ToolTip is showing correctly.
Thank you.
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
Hi where can we see this option in qliksense vizlib table.Please guide me