two ideas for this:
a) create an expression within listbox (instead of one single field):
=Year & '/' & Month & '/' & Tag
and check "View in treeview"
b) create a according Drill Down Group with Year, Month, .... (see document propers --> group Tab ...)
After creation use it in the listbox
Create a string that will look like this as an example
and in your list box click the 'show as tree view' with pipe as your delimiter, '|'
to create the string simply do Year(DateField)&'|'&Month(DateField)&'|'&Day(DateField)
The trick is to create a field that contains the level at each level with a added delimiter. In the attached qvw I wanted to show you what your field needs to look like to achieve the correct hierarchy. You have to take advantage of the peek function in this case.
For now I have used some rudimentary if statements to achieve what you wanted. let me know if you come right man
Date Hierarchy.qvw 146.2 K
You can do something quite simple:
LOAD Date, Year & '|' & MonthName(Date) & '|' & Date as Path
LOAD Date, Year & '|' & MonthName(Date) as Path
LOAD Date, Year as Path
Where Time is a first table with some dates, months and year fields, as you have.
By creating a second table, you will multiply the lines between Path (pls rename it) and the dates. So that you can choose a year and get data in your chart.
In the listbox, choose the Path field, and choose the delimiter (here the pipe) to get a treeview