topic Re: Drill Down in QlikView

Drill Down

Fri, 04 May 2012 06:10:53 GMT

I have created a drilldown group with Region, District and Territory. Now when i click on any Region it drills down to District, Clciking District drills down to Territory. Now if i am clicking on Territory only one Territory is selected and other territories get excluded. I want that even if i click on any Territory then all the Territories in a particular district should appear without excluding the other possible Territories in that particular District (i.e. it should not drilldown further after Territory). How this can be down ?

Drill Down

martinpohl — Fri, 04 May 2012 06:47:07 GMT

maybe change the type of the group from drill down to cycle?

Regards

Drill Down

Fri, 04 May 2012 06:59:14 GMT

I can not do that. My requirement is such that i have to use Drill Down Group only.

Re: Drill Down

Fri, 04 May 2012 07:05:55 GMT

What you can do, is build a trigger to prevent the selection of any Territory value. This trigger will undo any made selection on territory immediately.

Please see my attached example.

You can find the trigger at Document Properties -> Triggers:

- Document Event Trigger 'OnAnySelect'

- Field Event Trigger 'OnSelect'

Drill Down

Fri, 04 May 2012 07:22:42 GMT

Thanks for the reply JV. But can i do this for a particular sheet. Because i have to show the selections of territories inother sheets. Through this trigger i can not select territories in my entire report. But i want this to happen only for one sheet.

Drill Down

Fri, 04 May 2012 07:29:42 GMT

Hi JV,

I have given the action in sheet properties. It is working fine but the problem is when i am moving to the previous sheet where i had selected some territory the selections are lost. i have to maintain my territory selection when i move back to the first sheet but this action is clearing the selection of territories.

Drill Down

Fri, 04 May 2012 07:37:30 GMT

Hi,

I am afraid you cannot restrict this to a single sheet. Unfortunately the Sheet triggers are more limited.

Re: Drill Down

Nicole-Smith — Fri, 04 May 2012 13:05:12 GMT

You can apply this on an object by object basis by using set analysis:

{<Territory = >} will cause any selections in Territory to not affect the chart.

(I have also attached the above .qvw with this applied to the chart.)

Re: Drill Down

Fri, 04 May 2012 13:58:13 GMT

Hi Nicole,
I have this expression but this is not working.

if(Segments='Advocates',

(SUM({$<%EPID={1}, Segment={'Advocates'}, TERRITORY=>}(eTRx_Volume_Change))/
(SUM({$<%EPID={1}, Segment={'Advocates'},TERRITORY=>}(eTRx_Volume))-
SUM({$<%EPID={1}, Segment={'Advocates'},TERRITORY=>}(eTRx_Volume_Change)))),

(SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change))/
(SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume))-
SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change)))))

How can i modify so that it works ??

Re: Drill Down

Nicole-Smith — Fri, 04 May 2012 15:46:33 GMT

Can you post a .qvw with sample data (or scramble the data that you already have)? I can't tell what is going on without actually seeing it.

Re: Drill Down

Wed, 09 May 2012 07:14:18 GMT

Finally got my answer.

if(GetCurrentField([DrillDownGroupName])= 'TERRITORY',

(SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume_Change))/
(SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume))-
SUM({$<%EPID={1}, Segment={'Splitters'},ZIP=, Name=,TERRITORY=>}(eTRx_Volume_Change)))),

(SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change))/
(SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume))-
SUM({$<%EPID={1}, Segment={'Splitters'},TERRITORY=>}(eTRx_Volume_Change)))))

Thanks