topic Duplicate column in LOAD in QlikView

Duplicate column in LOAD

Anonymous — Wed, 12 May 2010 19:39:28 GMT

I have a date column in a pipe delimited text file. I created an expression year(date) and displayed the year in a list box. I created another list box having value month(date). Since the 2 list-box are derived from the same field, I cannot do a logical drill. Say I select year 2010, & then withing 2010, I want to select Jan. When I select Jan, it de-selects the year 2010 & shows all years which has Jan as a valid column.

I think Qlickview is filtering at the field lever & not at the expression level. One solution is to duplicate the field at the LOAD level. How can I duplicate that in the LOAD statement? Any other solutions?

Thanks,

Dinesh.

Duplicate column in LOAD

Wed, 12 May 2010 19:43:19 GMT

year(date) as [Year],

month(date) as [Month];

Enter this in the load statement, and change the names to whatever you wish!

Duplicate column in LOAD

villafuerte — Wed, 12 May 2010 19:46:30 GMT

Hi,

That's strange, it should keep your year selection and show the "available" months. Can you send a dummy file to check it please?

Cheers

Duplicate column in LOAD

Anonymous — Wed, 12 May 2010 19:53:50 GMT

I believe that is how Qlickview is designed. Once I duplicated at the load level, I am all set.

Thanks,

Dinesh.