Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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