Duplicate column in LOAD

[Anonymous]

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.

[#2 · Accepted solution]

year(date) as [Year],

month(date) as [Month];

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

[villafuerte]

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

[Anonymous]

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

Thanks,

Dinesh.