topic Re: Calendar Date problem in QlikView

Calendar Date problem

jeevays7 — Fri, 04 May 2018 13:59:11 GMT

Hi All,

I have reloaded the document and pasted in server. while accessing the document in browser the Date is displaying as "30-Dec-1899".

It is happening frequently and i don't know the reason.

Can someone please help me to resolve this?

PFA.,

olivierrobin — Fri, 04 May 2018 14:08:19 GMT

hello

it is because your field is either empty or null, so it shows the lowest available date

jeevays7 — Fri, 04 May 2018 14:24:21 GMT

Hi Oliver,

here i'm using a variable to show the date.

jeevays7 — Fri, 04 May 2018 14:26:38 GMT

if i am passing a null value, it is showing null only in the calendar. i tried in a sample application.

olivierrobin — Fri, 04 May 2018 14:28:28 GMT

and what's the content of that variable

put in in a text box to see it (I would say space)

rafatashiro — Fri, 04 May 2018 14:28:54 GMT

Use the variable "To" like this :

Max(Not null(Data))

olivierrobin — Fri, 04 May 2018 14:30:42 GMT

I tried and i see 30-dec-1899 when the variable contains 0

jeevays7 — Fri, 04 May 2018 14:33:58 GMT

The content of the variable is Max({1}Date) only.

jeevays7 — Fri, 04 May 2018 14:34:53 GMT

could you please send me a sample application with this case?

olivierrobin — Fri, 04 May 2018 14:37:58 GMT

the syntax looks like a set analysis

is is what you see in text box ? or the formula you use ?

the variable should contains a valid date if you want to see it in your calendar

jeevays7 — Fri, 04 May 2018 14:56:28 GMT

Yes Oliver, the syntax is a set analysis.

and the problem is with only the browser view. when i open the application using qlikview it looks fine.

olivierrobin — Fri, 04 May 2018 15:02:57 GMT

there's something I don't understand . Could you post the formula you use to populate your variable ?