Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Drill Down

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 ?

10 Replies
Not applicable
Author

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