topic Re: Month_MonthName_Year in QlikView

Month_MonthName_Year

Tue, 24 Feb 2015 10:00:27 GMT

Hi Community,

while loading the dates from a qvd. i am facing below problem.

Here Month is not linked with the year. When i select year e.g 2014 and select month ,QlikView automatically select the years of months in which the data available.

Snapshot .

Here i first selected Year 2014 and then i have selected Month Sep Now you see 2014 & 2013 Turns White.

Why this is reflecting such behavior?.

My QlikView version is

Note: Due to security reasons i am not able to attach the data.

Re: Month_MonthName_Year

MK_QSL — Tue, 24 Feb 2015 10:05:36 GMT

Provide your script for Month, Year and MonthYear field.

Re: Month_MonthName_Year

jonathandienst — Tue, 24 Feb 2015 10:13:29 GMT

Judging from the images, it looks like you have expressions in the list boxes. I suggest you post those expressions as well as the model schema and load script.

Jonathan

Re: Month_MonthName_Year

Anonymous — Tue, 24 Feb 2015 10:18:49 GMT

Identifying these kind of issues by images is difficult. It looks like you don't have a common key (primary key) joining all these fields if they are in different tables.

Please post your script and the expression you are using for your list box object.

Re: Month_MonthName_Year

Tue, 24 Feb 2015 10:25:41 GMT

You should create the Year and Month field from the "Month Year" field.

How you are creating you calendar, that can help us identify the cause.

Thanks,

Singh