topic Re: calendar in QlikView

calendar

master_student — Mon, 07 Nov 2016 08:34:25 GMT

Hello guys,

I would like to add a calendar in my Dashbord, and I want that calendar to contain maximum date in my calendar dimension.

any idea ?

Thanks a lot

Re: calendar

MK_QSL — Mon, 07 Nov 2016 08:43:10 GMT

What do you mean by Maximum date. Kindly provide some more information.

Re: calendar

dineshm030 — Mon, 07 Nov 2016 09:02:10 GMT

Hi,

Can you please provide sample data?

Re: calendar

robert_mika — Mon, 07 Nov 2016 09:03:30 GMT

Master calendar

Creating A Master Calendar‌

and then you can add

Max(Date) as MaximuDate

to get the highest date, but as Manish pointed it depends on which dimension you want to use for that date.

Please give more information .

Re: calendar

its_anandrjs — Mon, 07 Nov 2016 09:09:54 GMT

Explain with an example or please provide sample doc for the same.

Regards

Anand

Re: calendar

tresB — Mon, 07 Nov 2016 09:17:42 GMT

A sample could be like:

Table:

Load * Inline [

DateFromYourData

1/1/2015

1/1/2016

1/2/2016

12/8/2016

];

Temp:

Load

max(DateFromYourData) as MaxDate,

min(DateFromYourData) as MinDate

Resident Table;

Drop Table Temp;

Let vMax=Peek('MaxDate');

Let vMin=Peek('MinDate');

MasterCalendar:

Load

Date($(vMin)+rowNo()-1) as Date

AutoGenerate $(vMax)-$(vMin)+1;

This would give you all dates between min (1/1/2015) and max(12/8/2016) dates in the available data i.e. date field.

Re: calendar

hemanthaanichet — Mon, 07 Nov 2016 09:18:42 GMT

Hi Wiem,

You can add calendar object in your dashboard

1. right click on sheet, New sheet Objects-> Slider/Calendar Object

2. In input style set is as calendar and select the field which u would like to show in calendar

Regards

Hemanth

Re: calendar

Mon, 07 Nov 2016 10:07:05 GMT

Hi WIEM,

You can use the Calendar Object and there put a maximun value there... Another option is to use a QlikView application that I put here. There you can put the oldest and newest dates, and crete the intermediate dates between those ones.

I hope the answer will help you