topic Re: Calendar Object in QlikView

Calendar Object

himabinduch — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

how to create two different calendars for from and to date of a field in qlikview

Thanks,

Hima

Re: Calendar Object

ahaahaaha — Tue, 07 Mar 2017 09:17:49 GMT

Hi Hima,

Create a calendar twice with different field names.

Regards,

Andrey

Re: Calendar Object

muthukumar77 — Tue, 07 Mar 2017 09:30:03 GMT

Hi,

1. Create calendar twice with diff. name.

2. Assume From data and To date as Date. Use this date into calendar.

Eg:

Load FromDate as Date,

.......

from table;

concatenate

Load Todate as Date,

.......

from table;

Re: Calendar Object

himabinduch — Tue, 07 Mar 2017 09:36:52 GMT

Hi Andrey,

i have only one field.

and i would like to create from and to empty calendar for user section. if i create two objects if i create to date then automatically the second one also reflecting i don't want that to happen

Re: Calendar Object

himabinduch — Tue, 07 Mar 2017 09:39:31 GMT

Hi Muthukumar,

i have only one field and i would like to create from and to calendar objects so that user can select the different date ranges what ever they want.

Re: Calendar Object

Anil_Babu_Samineni — Tue, 07 Mar 2017 09:42:36 GMT

Create two variables vStartDate = Min(DateFieldName) and vEndDate = Max(DateFieldName)

Then take Calendar object and call vStartDate as Variable and use Min(DateFieldName) under Min section and Max(DateFieldName) under Max Section

Then, Create one more object using vEndDate and then call $(vStartDate)-1 under min section and Max(DateFieldName) under max section.

Then look, I am 100% sure it won't effect if you follow me. If not, You may share the application so that we can sort it out for you the wrong which you make

Re: Calendar Object

muthukumar77 — Tue, 07 Mar 2017 09:44:31 GMT

Ok.

refer this app,

Re: Calendar Object

himabinduch — Tue, 07 Mar 2017 10:00:18 GMT

Hi Muthukumar,

Yes,i need calendar object like that but it should not show any date as fixed date(min date) in the start date.

Re: Calendar Object

yasmeenk — Tue, 07 Mar 2017 10:49:56 GMT

Hi,

Like this?