Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
year(date) as [Year],
month(date) as [Month];
Enter this in the load statement, and change the names to whatever you wish!
year(date) as [Year],
month(date) as [Month];
Enter this in the load statement, and change the names to whatever you wish!
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
I believe that is how Qlickview is designed. Once I duplicated at the load level, I am all set.
Thanks,
Dinesh.