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

[sarsukanth]

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

[edwin]

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

[VictorAE]

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 "{<>}".

[felcar2013]

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

[edwin]

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

[edwin]

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
,' ')

[felcar2013]

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')&'<br><br>'&
CONCAT({<Day={'Mon'}>} Event_Name&'<br><br >')
)

[edwin]

yw

[edwin]

just curious is <br> working for you?

[felcar2013]

yes, need to tick box "text is html"