topic Re: Calendar Object in QlikView

Calendar Object

krishna20 — Wed, 28 Jan 2015 06:28:33 GMT

Hi Friends,

In calendar Object i have taken at Min Value as Min(Date) and at Max Value as Max(Date). My date is displaying correctly. I need to show DD/MM/YYYY as default at date displayed place.Please find the below snapshot for my exact one which i'm looking for.

Regards

Krishna

Re: Calendar Object

ashfaq_haseeb — Wed, 28 Jan 2015 06:47:08 GMT

Hi,

Try by changing the format in script editor.

Regards

ASHFAQ

Re: Calendar Object

Wed, 28 Jan 2015 06:53:30 GMT

Hi,

You can change the format in the variable definition itself.

=date(min([release date]),'DD-MM-YYYY')

Regards

Sudha E

Re: Calendar Object

krishna20 — Wed, 28 Jan 2015 06:53:53 GMT

Hi Ali,

I need to display the DD/MM/YYYY as a string at my date place.

Regards

Krishna

Re: Calendar Object

its_anandrjs — Wed, 28 Jan 2015 07:00:19 GMT

Hi,

If you are using the variables in object then change its definition in variables

Ex:-

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

=Date( DateField,'DD/MM/YYYY')

Or you can directly change this settings in the calendar object.

Regards

Anand

Re: Calendar Object

SreeniJD — Wed, 28 Jan 2015 07:28:56 GMT

Hi Krishna,

If you want to display current date then use the below expression....

=date(min(now()),'DD/MM/YYYY')

If you want to select the date from the date selector, then you can always create a user defined function and replace Now() with your user defined function.

Let me know if this helps!

Regards,

Sreeni

Re: Calendar Object

krishna20 — Wed, 28 Jan 2015 07:32:57 GMT

Hi All,

I need to show here that my date format is in DD/MM/YYYY . To display at my date place as DD/MM/YYYY which is like a string.

Regards

Krishna

Re: Calendar Object

Wed, 28 Jan 2015 08:30:00 GMT

can u try dual function?