Month_MonthName_Year

[#1]

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.

[MK_QSL]

Provide your script for Month, Year and MonthYear field.

[jonathandienst]

Hi

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

[Anonymous]

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.

[#5]

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