calendar

[master_student]

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

[MK_QSL]

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

[dineshm030]

Hi,

Can you please provide sample data?

[robert_mika]

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 .

[its_anandrjs]

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

Regards

Anand

[tresesco]

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.

[hemanthaanichet]

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

[#8]

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