Time Drill Down Problems

[anuradhaa]

Hi,

I have a date in yyyy/mm/dd format.

Then create bar cahrt and use date in demenssion.

in demenssion i use Group and time drill down.

but it is not working properly.

then i use calender table and use it. but it also not working properly.

I have attached qvw. pls check it and help me to solve this problem.

I need to show the data by Year,month,month-day

also use can select year,month, date using list box.

Thanks

[fdelacal]

see if qvw atach solve your problem.

Regards

[anuradhaa]

Hi Thanks for you reply.

But this is not the thing that i want.

I don't want to use cyclic groups.

Here waht is need to show is,

first display the data by year. no selections made.

Then when i select year in the list box, display the data by month. then user can use drill down to see year data also.

Then when he select month in list box display the days in chart.here i use dates ad mm-dd format

So when he select multiple months display the dates belongs to multiple months

Also when a user select specific date useing year,month,date list boxoes then display only that date.

You can see Some of the things are not working in my chart.

Thanks

[anuradhaa]

Actually i want to show dates belowngs to multiple months when i select multiple months.

but it doesn't show in the chart

[calvindk]

Here you go:

Don't use a drilldown, but use dimension T_Month and T_Day and use conditional show.

if( Wildmatch(GetCurrentSelections() , '*Month*'), 0,1)

if( Wildmatch(GetCurrentSelections() , '*Month*'), 1,0)

Best wishes

[anuradhaa]

Hi ,

please reffer my attached qvw. you can use attached xcl for look at my data set

Here i need to do below things.

1. display yearly data when no selections made. - currently it displys monthly

2.Display all data, date wise when i select may and april. but it only display montly data.

Those are the two main questions i have.

Please help me to solve this problem

Thanks

[anuradhaa]

Hi, thanks for your reply, but this is not the thing that i want.

Thanks

[calvindk]

I dont see how that will not be solved in the way i proposed?

Use conditional show on dimensions.

[Anonymous]

And is there a reason why you don't want to use a Cyclic Group? Because you just listed all of the limitations of the Drill Down Group..

1. Drill Down jumps automatically to the next in row if the previous only has one value (so if you would have more than one year, year would be the data you'd see when nothing is selected)

2. you can only drill up with the arrow and drill down with clicking, and clicking 2 thing in one time, isn't easy..

But all these problems are solved when you would use a Cyclic group..

[anuradhaa]

when i used that it will create another problem. it can't seperate data by months. when i select 15 and have april and may data it sum that.

but that is not what i need. pls see my newly attached qvw. and new post then you can have a better idea about my problem. thanks for your advise and appriciate.

Thanks again