Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Drilldown Dimension

Hi,

I am really confused with the drill down group behavior.

I have created a table with 3 columns.

UNIV:

Territory,

sum

Count

The above table is joined with rest of the data model based on the Territory. So, from another table

named KIT I pulled Area, Region and Territory and created a drill down group.

I created a bar chart with

dimension as a drill down group with Area, Region and Territory and

Expressions as Sum and Count from UNIV Table.

But Surprisingly the above drilldown group is not working (i.e., I cant see the area and region in Bar chart, But when I select Territory from list box its working)

Can Someone pls help me working this out!

Thanks in advance!

Rohini.M

13 Replies
MVP
MVP

Re: Drilldown Dimension

This probably isn't it, but your drill down dimensions have to be listed in the right order, from broadest to narrowest. So for instance Year, Month, Day. I can't tell from the field names which order Area, Region, and Territory should be in, but perhaps they're not in the right order?

Khan_Mohammed
Honored Contributor II

Re: Drilldown Dimension

It should work both way.

Selecting fields on Chart or Filters.

There is no reason for not working.

Not applicable

Re: Drilldown Dimension

Thank you for reply!

The order is Area->Region->Territory. I created drill down in same order John. That's why am surprised by the result.

Can you pls help me if I can find any other way to work this out.

Not applicable

Re: Drilldown Dimension

Yes Aravind. That is what I expected and I cross checked with order and dimensions too. Somehow its not working.

vishsaggi
Esteemed Contributor III

Re: Drilldown Dimension

Can you show us the data model or the script you used for joining tables?

Khan_Mohammed
Honored Contributor II

Re: Drilldown Dimension

There can be issue with the script.

Can you post sample data or qvw?

Not applicable

Re: Drilldown Dimension

Hi,

Pls find Script below

KIt:

SQL Select Kit, Kitreceived, Area, Region, Territory from reporting.kits_received ;

Qualify*;

Unqualify Territory;

UNIV7_Req_Summary:

SQL select Territory, count(kit_ID);

Not applicable

Re: Drilldown Dimension

Sorry, I cannot share the data model. But, I posted the script. Pls go thr'. We are loading all the tables from SQL Queries.

vishsaggi
Esteemed Contributor III

Re: Drilldown Dimension

Qualify*;

Unqualify Territory;

UNIV7_Req_Summary:

SQL select Territory, count(kit_ID);

In the Above script are you using Group By clause because you are using Aggr function count().?

something like this may be?

SQL select Territory, count(kit_ID) AS KitCount

Group by Territory;


And were both the tables joined by Territory or some other field ?