topic Re: Time Drill Down Problems in QlikView

Time Drill Down Problems

anuradhaa — Tue, 07 May 2013 07:09:05 GMT

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

Re: Time Drill Down Problems

fdelacal — Tue, 07 May 2013 07:19:21 GMT

see if qvw atach solve your problem.

Regards

Re: Time Drill Down Problems

anuradhaa — Tue, 07 May 2013 07:26:20 GMT

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

Re: Time Drill Down Problems

anuradhaa — Tue, 07 May 2013 08:30:10 GMT

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

but it doesn't show in the chart

Re: Time Drill Down Problems

calvindk — Tue, 07 May 2013 08:41:44 GMT

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

Re: Time Drill Down Problems

anuradhaa — Tue, 07 May 2013 09:12:08 GMT

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

Re: Time Drill Down Problems

anuradhaa — Tue, 07 May 2013 09:12:43 GMT

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

Thanks

Re: Time Drill Down Problems

calvindk — Tue, 07 May 2013 09:46:59 GMT

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

Use conditional show on dimensions.

Re: Time Drill Down Problems

Anonymous — Tue, 07 May 2013 10:08:40 GMT

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..

Re: Time Drill Down Problems

anuradhaa — Tue, 07 May 2013 10:24:03 GMT

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

Re: Time Drill Down Problems

anuradhaa — Tue, 07 May 2013 11:50:42 GMT

Great. It works.

I have adjest it to fix this with my data. another one thing.

what can i do if i have more than one year.

Thanks