topic Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible? in App Development

Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

sarsukanth — Thu, 24 Jun 2021 14:03:03 GMT

Hi All,

We need a Grid type Calendar view in a Qlik Sense page which need to show day wise events, just like Calendar view in Outlook.

Is this view possible in Qlik Sense ?

If yes please let us know how to do the same.

Thank you,

Raghu

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

edwin — Fri, 25 Jun 2021 20:01:01 GMT

without the use of an extension, it is not possible to imitate the calendar in Qlik Sense.

the problem is that you need Week as a dimension bec in a calendar, the dates are ordered by week rows. in QlikView you can hide a column but not in Qlik Sense. try this:

Calendar: load Date, week(Date) as Week, WeekDay(Date) as Day, month(Date) as Month, year(Date) as Year; load Date(today()-iterno()) as Date While iterno()<90; load 1 AutoGenerate(1); data: load Date, rand()*1000 as Amount Resident Calendar;

filter of a specific Month, then create a table chart:

dim is Week

+ 7 expressions starting with Sun:

if(count({<Day={'Sun'}>}Date)>0, Date(only({<Day={'Sun'}>}Date),'DD') & ' ' & num(Sum({<Day={'Sun'}>}Amount),'#.##') ,' ')

create 6 more for the other days:

as yo can see, since you cant hide the week column, it ruins the visual

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

VictorAE — Mon, 04 Jul 2022 19:21:06 GMT

Hi, Edwin.

I'm trying to do this "calendar" with similar information but i can't.
Do you know if this still work?

If this still works maybe I'm confusing the fields name with the functions name, so if you can help me to distinct where is the function or the field i'll be thankfull.

And finally i don't know the function of the symbols "{<>}".

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

felcar2013 — Mon, 11 Jul 2022 18:58:42 GMT

This calendar does not work if we have more than one "Amount". do you have a solution for it?

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

edwin — Tue, 12 Jul 2022 16:24:43 GMT

the symbols {<>} indicates set analysis. post a picture of your data model and your expression and maybe i or someone will be able to help

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

edwin — Tue, 12 Jul 2022 16:26:09 GMT

the cell is a composite of the "DAY" and the measure separated by CR. if you need more than one measure just add it into the expression:

if(count({<Day={'Sun'}>}Date)>0, Date(only({<Day={'Sun'}>}Date),'DD') & ' ' & num(Sum({<Day={'Sun'}>}Amount),'#.##') & ' ' & yourseconexpressionhere ,' ')

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

felcar2013 — Tue, 12 Jul 2022 16:31:30 GMT

Thanks!

my "amount" were different strings related to the same Event_Date and I solved the expression with this formula:

IF(COUNT({<Day={'Mon'}>} Event_Date)>0,DATE(ONLY({<Day={'Mon'}>}Event_Date),'DD')&' '&
CONCAT({<Day={'Mon'}>} Event_Name&' ')
)

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

edwin — Tue, 12 Jul 2022 17:04:03 GMT

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

edwin — Tue, 12 Jul 2022 19:33:23 GMT

just curious is working for you?

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

felcar2013 — Tue, 12 Jul 2022 19:38:56 GMT

yes, need to tick box "text is html"

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

edwin — Tue, 12 Jul 2022 20:16:18 GMT

are you using QlikView or Qlik Sense?

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

felcar2013 — Tue, 12 Jul 2022 20:55:06 GMT

good question, I am using sense. I think for qlikview you could better use chr(10) or chr(13), not sure

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

edwin — Wed, 13 Jul 2022 00:14:06 GMT

heres a great post for set analysis:

https://community.qlik.com/t5/Qlik-Education-Documents/Set-Analysis-Presentation-pdf/ta-p/1487937?attachment-id=123801

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

issiakaimg — Mon, 26 Sep 2022 23:44:28 GMT

I also searched a lot for such a type of calendar and all the forums for it. Finally, I found a printable October 2022 calendar that fits perfectly for my projects.

Re: Need a Grid type Calendar view which contains and show daily events from a table, is it possible?

issiakaimg — Thu, 29 Sep 2022 23:29:04 GMT

I also searched a lot for such a type of calendar and all the forums for it. Finally, I found a printable October 2022 calendar that fits perfectly for my projects. This grid calendar is a great way to view daily events from a table. It is easy to see what is happening each day and track the events' progress. This type of calendar is also easy to print out and share with others. I recommend using their template because it is easy to take notes there and set some reminders for future events.