topic Re: variable value empty in calendar in QlikView

variable value empty in calendar

Anonymous — Thu, 20 Nov 2014 15:20:27 GMT

Hi, all,

I use 2 variable as the vStartDate and vEndDate to get a arbitrary date range. And also create a trigger to return the value of vStartDate and vEndDate if a date range is selected from the Date dimension.

This works before when I use "D-M-YYYY" format, which is the default format of the system. And now I changed all to use "DD.MM.YYYY" format, then Input box object performs the same as before, but the Calender will only show the value of the variables if you select the date in the calender. The two variables still get the date value back if Date dimension is selected, but in the calender, the value dose not display anymore!!!

In the attached .qvw, you can see that the calendar objects Start and End are empty, but the calender objects S and E have the value from the 2 variables.

Note: when I provide the 2nd example with DateOld dimension for comparison, for some reason, the selection on the DateOld dimension dose not work as well. And normally vS and vE should change if you select on DateOld.

I tried to change the format in the calendar as well, but it dose not work.

BTW, I use the newest version 11.20 SR9

Any one has any clue?

Thanks very much

Zhihong

Re: variable value empty in calendar

Anonymous — Thu, 27 Nov 2014 15:15:17 GMT

Still an open issue for us. Thought we work around this by adding a text object to show the date in the calender. But it can cause ugly layout problem. Dose anyone have a clue about this?

Thanks

Zhihong

Re: Re: variable value empty in calendar

Anonymous — Thu, 27 Nov 2014 15:40:01 GMT

How about something like this ?

Re: Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 11:56:55 GMT

Hi, Bill,

Yes, you are correct, We can first keep using "D-M-YYYY" format, and change to "DD.MM.YYYY" in the final step to display the date, though more date related columns need to be changed in the final step, but it works.

Thanks

Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 12:02:15 GMT

in my qvw all the date are stored, compared & manipulated as QlikView dates.

You can display them in whatever format you wish, without affecting any processing or logic ?

Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 12:24:43 GMT

Hi, Bill,

Thanks for your reply, the thing is like this. For the date, it is a format thing, and it dose not break the logic in the dash, even when we use "DD.MM.YYYY".

The default date after LOAD from the script is "D-M-YYYY". As the client need "DD.MM.YYYY" format in the dash for all columns, text and calender object, so we changed the format in the LOAD script (as in my .qvw file). As we think by doing this we do not need to modify the format every where in the dash. Then it caused a problem in the date display in the calender object. But no logic is affected. From your reply, then I realize that we can keep using "D-M-YYYY" format. And modify the date format when we need to display it as "DD.MM.YYYY".

Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 12:29:20 GMT

In your load script you can set the default date format like this :

SET DateFormat='DD.MM.YYYY';

So dates will by default always be displayed in that format, unless you manually override it.

Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 12:35:13 GMT

Hi, Bill,

Yes, we tried this, then we have problem to display it in the calender object. If use a trigger in date field, and select date, the variables used for the calender object get the correct value, but the value never show up. That is the problem I have in the first place.

Re: Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 12:44:03 GMT

Have a look at the attached.

Everything is stored as QlikView dates and :

The default date format is D-M-YYYY
All dates are displayed in D-M-YYYY format
All the calendar objects, triggers & date selections display & work ok

Re: Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 13:00:10 GMT

Hi, Bill,

Thanks for your time. I am sorry that my description confused you, but you did not understand my issue. In my original .qvw file, I gave tow examples, one using "D-M-YYYY", all works perfect, the calendar, tiggers and date selection, just like your. And I never mentioned that I have problem when using date format as '"D-M-YYYY". The second example in my .qvw file is using "DD.MM.YYYY", and all other work except the calendar.

Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 13:04:42 GMT

So to get closure, is it all working correctly now ?

Re: variable value empty in calendar

Anonymous — Fri, 28 Nov 2014 13:10:51 GMT

No, it is not. But by your first reply. I suddenly realize that we can work around it by keeping using 'D-M-YYYY', but override the format when need to show the date as 'DD.MM.YYYY'.