topic Re: Selectable Calendar Object in QlikView

Selectable Calendar Object

Thu, 02 Jan 2014 19:38:02 GMT

Hello everyone,

I would like to see if you guys got any idea of how i can create an object like a calendar and be able to select the items inside.

Let me explain.

I got an excel database that has dates that indicate an arrival.

I need to have an object that from today's week (Week(Today())), it shows on the respective week day if i have an arrival and to be able to select it so i can show the arrival's information on an aditional text item.

It could look something like:

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
-	-	Arrival	-	-	-	-
-	-	-	-	-	-	-
Arrival	-	-	Arrival	-		-
-	-	-	-	-	Arrival	-

Then just select any arrival and have the info displayed.

I just need help on how to create the object from above.

Any ideas?

thanks

Re: Selectable Calendar Object

Nicole-Smith — Thu, 02 Jan 2014 19:40:10 GMT

What does your data from the Excel database look like? We can give you a better example if we know how the data looks. Can you post a small example?

Re: Selectable Calendar Object

Thu, 02 Jan 2014 19:49:27 GMT

Hi Mariana,

This is sample script,

TempCalendar:

LOAD

$(varMinDate) + rowno() - 1 AS DateNumber,

date ($(varMinDate) + rowno() - 1) AS TempDate

AUTOGENERATE

$(varMaxDate) - $(varMinDate) + 1;

LOAD TempDate as OrderDate,

Week(TempDate) as Week,

Year(TempDate) as Year,

Month(TempDate) as Month,

Day(TempDate) as Day,

WeekDay(TempDate) as WeekDay,

Chr(81)& Ceil(Month(TempDate)/3) as Quarter,

QuarterName(TempDate) as QuarterName,

QuarterStart(TempDate) as QuarterStart,

QuarterEnd(TempDate) as QuarterEnd,

MonthName(TempDate) as MonthName,

MonthsName(3,TempDate) as MonthsName,

MonthStart(TempDate) as MonthStart,

MonthEnd(TempDate) as MonthEnd,

WeekYear(TempDate) as WeekYear,

Week(TempDate) & '-' & Year(TempDate) as WeakYear1,

InYear($(varToday),TempDate,1) as Inyear,

InYearToDate(TempDate,$(varToday), 0)*-1 AS CurYTDFlag,

Inyeartodate (TempDate, $(varToday), -1)*-1 AS LastYTDFlag,

$(varToday) as Today

Resident TempCalendar

Order by TempDate asc;

Re: Selectable Calendar Object

Thu, 02 Jan 2014 19:51:33 GMT

It contains a Date column, of the arrival, and more columns with info (quant, name, description, etc) thats gonna be displayed after the selection. There's no unique ID.

The date have the year its just the displayed format.

Re: Selectable Calendar Object

Thu, 02 Jan 2014 22:18:45 GMT

I think this is like a Table asociating the Date with a Calendar object in the scirpt.

I was looking for something to order the arrivals in an user friendly object for selecting.

I'm just not sure on how to build this object to display what i need.

Re: Re: Selectable Calendar Object

Nicole-Smith — Fri, 03 Jan 2014 19:56:21 GMT

Do you really need to display it like you have above, or is a list box that only shows dates from the current week and the day of the week it falls on enough (see attached for full example)?

If you need it like you have above, I'm not sure of a simple way to do it. It seems like you would need to hack something up in order to get what you want.