Drill-down option is not working in "Line chart"

[#1]

Dear All,

I have designed 'Line Chart" to implement the Drill-Down option for the Year-Quarter-month.

I am getting "No data to display" message when I selected year 2010 in Line chart (even though there are 124 records for the year 2010). Even I am getting same problem when I select other combinations (year wise and quarter wise).

Could anybody take a look in my demo application (QlikView version 9.0.) and solve my problem?

I am sorry to say that, the data is loaded from my test application and has junk data. 😞

Thanks in advance.

[#2]

When I downloaded your file and tried to select 2010 the chart showed me Q2,Q3 and Q4 and when I select a quarter it gave me a specific month.

I think theres nothing wrong with your attached demo..

I'm using Qv 10...

[#3]

Hi,

Even I didn't face the problem when I put the cursor on top of the line bar for the year 2010. It shows proper result. But, when I click the year 2010, I am getting the problem.

Is there any problem with QlikView Version 9.0?

[#4]

This is the picture of what i encountered when i tested your demo.

I'm not sure if there's something wrong with Qv 9.

[Anonymous]

I think you should try to make it a cyclic group instead of a Droll-down group. Is that an option?

[#6]

Hello,

take a look at your data. Create a table box with Year, Quarter and Inv_Month. You will see some nullvalues. I am sure you do not want them anyway. They are the reason for the funny behaviour of your chart. If you correct your data the chart should also work as you expect it, indendent of the QV-version. Donn't hesitate to post the "new" app.

Regards, Roland

[#7]

Hi Roland,

I have created a table box as you suggested. Also, I have suppressed the nullvalues by using where condition.

Now, when I select the data for year 2010, it shows the data for 2002 and the other way also.

Please take a look in my updated application. Please solve my problem.

Thanks in advance.

[#8]

Hi,

I checked your data modell. There has something to be changed. You link your "calender" only with month_nbr. That's not enough. You need the year also. When you choose a month_nbr in your existing modell QV will select (and has to select) all according rows with that month_nbr, regardless of the year.

One idea is to create a calendertable with Year, Quarter, Month (twelve rows a Year) and link it to Staecon via year and month_nbr. This would be a first step. Next could be to link the tables not with the two fields but creating a unique key using month_rnbr and year.

HtH

Roland

[#9]

Hello,

in addition to my post above check my application.Forget about the field "Year", this is for testing only.

RR

[#10]

Hi Roland,

Thanks a lot for your interest on this.

I am sorry to say that, when I selected the year 2010 on chart in your application, it's selected the data for the year 2002. 😞

But, when I clik on top of the Line-Bar for the year 2010, it shows the correct data.

Is this any settings (either chart or QlikView-software) related problem?

Thanks in advance.