topic Re: Issue with Calendar Funktion in QlikView

Issue with Calendar Funktion

Thu, 04 Dec 2014 08:25:05 GMT

Hi all

I have a very stupid issue with my calendar and I don't know how to solve it...

I want to install some pre-settings when somebody choose this tab. Therefore I installed an Aktion, that QV will select the current month.

It worked until December, I found out that the formula month(today()) returns "Dez" for December. In the integrated calendar December is writting with a "c" ==> Dec.

How can I solve this? Any ideas? Thanks for your help.

Oliver

=Month(today())

Re: Issue with Calendar Funktion

mato32188 — Thu, 04 Dec 2014 08:29:43 GMT

Hi Oliver,

check your variable settings in script ....set MonthNames = ...

Re: Issue with Calendar Funktion

morganaaron — Thu, 04 Dec 2014 08:31:30 GMT

Hi Oliver,

It should be picking up the Month Name value from the SET statement in (by default) the Main tab in your load script - the statement will set the short month names that are used by that function, so 'Jan;Feb;Mar...' etc.

Check here that December is represented by Dec not Dez.

Re: Issue with Calendar Funktion

MarcoWedel — Thu, 04 Dec 2014 08:58:52 GMT

Hallo Oliver,

like already suggested you have to check your MonthNames variable in the script.

Like your screenshot suggests, instead of the german default definition for MonthNames:

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

your script might actually look like:

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dec';

Can you post a sample app to clarify?

Gruß

Marco

Re: Issue with Calendar Funktion

Thu, 04 Dec 2014 09:01:15 GMT

hi all

this is very strange

I changed it in the datamodel and checked it everywhere (saving, reloading, etc.)

but it's still there...

Any ideas? Unfortunately I cannot post a sample...

Re: Issue with Calendar Funktion

mato32188 — Thu, 04 Dec 2014 09:09:24 GMT

Hope, you havent missed variable settings at the very begining of your script...

set

if not, check your variables by Ctrl+Alt+V to be sure, you are not using any other formating for your month list box, else check your formating in list box directly.

Re: Issue with Calendar Funktion

Thu, 04 Dec 2014 09:11:35 GMT

found it

Thank you very much for your help!

Re: Issue with Calendar Funktion

sujeetsingh — Thu, 04 Dec 2014 11:06:00 GMT

Check for this script

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';