topic Re: Listbox Calender in QlikView

Listbox Calender

NavinReddy — Mon, 22 Jul 2013 12:10:34 GMT

Hi All,

how can i able to create calendar in listbox

plz find the attechment like the way i need

Thanks,

Rohith

Re: Listbox Calender

kaushiknsolanki — Mon, 22 Jul 2013 12:12:27 GMT

Hi,

Its not possible to create a calander in listbox.

You can use the Calander object as you have shown to make selections.

If you need you can also set that object to take multiple values.

Regards,

Kaushik Solanki

Re: Listbox Calender

NavinReddy — Mon, 22 Jul 2013 12:28:10 GMT

Hi Kaushik,

Thanks for your reply

its there any code for develope calendar in listbox

Thanks,

rohith

Re: Listbox Calender

kaushiknsolanki — Mon, 22 Jul 2013 12:30:38 GMT

Hi,

As far as i know no.

But tell me one thing why you want calander in listbox.

Regards,

Kaushik Solanki

Re: Listbox Calender

NavinReddy — Mon, 22 Jul 2013 12:35:42 GMT

Hi,

purpose of Using WTD,there i can able to select Specific date

i got this code in community i got some error help me to solve

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

TempCalendar:

LOAD

$(varMinDate) + Iterno()-1 As Num,

Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1

While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

MasterCalendar:

Load

TempDate AS OrderDate,

week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month,

Day(TempDate) As Day,

YeartoDate(TempDate)*-1 as CurYTDFlag,

YeartoDate(TempDate,-1)*-1 as LastYTDFlag,

inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,

date(monthstart(TempDate), 'MMM-YYYY') as MonthYear,

ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

WeekDay(TempDate) as WeekDay

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

Thanks,

rohith

Re: Listbox Calender

kaushiknsolanki — Mon, 22 Jul 2013 12:37:44 GMT

Hi,

First Tell me what is the error you got.

Secondly use the degub to know whether the variables are holding the data.

Regards,

Kaushik Solanki

Re: Listbox Calender

Mon, 22 Jul 2013 12:43:31 GMT

Hi..u want this only..

Create a variable

vDate =Date(MonthStart(Today()),'DD/MM/YYYY')

Create a calender object > Date Variables select vDate

then exp

Min Value =Date(MakeDate(2012,1,1),'DD/MM/YYYY')

Max Value =Date(Today(),'DD/MM/YYYY')

hope u will get ur result in ur imagewise..

regards-bika