topic Re: Drilldown Dimension in QlikView

Drilldown Dimension

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Drilldown Dimension

johnw — Wed, 07 Dec 2016 19:19:09 GMT

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?

Re: Drilldown Dimension

MK9885 — Wed, 07 Dec 2016 19:20:58 GMT

It should work both way.

Selecting fields on Chart or Filters.

There is no reason for not working.

Re: Drilldown Dimension

Wed, 07 Dec 2016 19:41:06 GMT

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.

Re: Drilldown Dimension

Wed, 07 Dec 2016 19:42:16 GMT

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

Re: Drilldown Dimension

vishsaggi — Wed, 07 Dec 2016 19:45:48 GMT

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

Re: Drilldown Dimension

MK9885 — Wed, 07 Dec 2016 19:47:37 GMT

There can be issue with the script.

Can you post sample data or qvw?

Re: Drilldown Dimension

Wed, 07 Dec 2016 19:51:09 GMT

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);

Re: Drilldown Dimension

Wed, 07 Dec 2016 19:52:34 GMT

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

Re: Drilldown Dimension

vishsaggi — Wed, 07 Dec 2016 20:00:14 GMT

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 ?

Re: Drilldown Dimension

Wed, 07 Dec 2016 20:04:39 GMT

Yes Vishwanath

I added group by Territory to my script and joined the tables based on territory. Still the problem is same.

Re: Drilldown Dimension

vishsaggi — Wed, 07 Dec 2016 20:11:28 GMT

Strange. Out of ideas. Will that be feasible to share your qvw file with scrambled data for a quick peek?

Scrambling Data

Re: Drilldown Dimension

Wed, 07 Dec 2016 20:31:03 GMT

Sorry Vishwanath

I cannot share my QVW file. Sorry about that

Re: Drilldown Dimension

Wed, 07 Dec 2016 22:05:26 GMT

I found the problem. I didn't use any aggregation function in expression. that's the reason Drill down didn't worked. Thank you all for your help