This content has been marked as final. Show 3 replies
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?