Documents & videos about Qlik Sense.
While using drill down function of QlikView, I have identified if count of any dimension is 1 then Drill down skip that dimension and goes to a next level.
We are having hierarchy called GEO which includes different level like Zone - > Country -> State -> Region … so on.
Drill Down Group: Create your drill down group.
Chart Using Drill Group: Add your dimensions and expression in straight table or your chart.
Output using Drill Down Group:
1) Drilling from Zone - > Country
2) Drilling from Country -> State
Issue comes here, because of Country = FN is having 1 State so it is jumping to next dimensions. To overcome this problem I have tried to demonstrate by using same example.
1) Create chart with all dimension which we have added in Drilldown Group as below screenshot.(Based on level of Hierarchy)
2) Add you expression
3) In dimension tab, follow the below steps. 1. In a first dimension add below condition, based on your number dimension.
Ex. GetSelectedCount(Zone)=0 andGetSelectedCount(Country)=0 and GetSelectedCount(State)=0 and GetSelectedCount(Region)=0…so on.
2. From Second dimension onwards, use below condition with minor changes for all.
Ex. If I am adding for Country
GetSelectedCount(Zone)>0 and GetSelectedCount(Country)=0 and GetSelectedCount(State)<1 and GetSelectedCount(Region)<1
If I am adding for next dimension of country which State then Before State condition should > 0 and after State it should be < 1(Excluding current dimension). For current dimension it should be = 0.
3. For last dimension,current dimension condition will change from =0 to >=0.
Ex.GetSelectedCount(Zone)>0and GetSelectedCount(Country)>0 and GetSelectedCount(State)>0 and GetSelectedCount(Region)>=0
Dry Run on Issue and Solution charts:
1) Initial View:
2) Drill on First Level:
3) Drill on Next level:
4) Final Drill Down:
Hope this may solve or help !!
Open for any suggestion or issue report.
****** Find Attached documents and application for reference ***************
Thanks for sharing this.
This kind of approach will really help.
Some days back same issue was addressed :
Drill Down Group issue
Hope this will add another way to resolve this issue
Any idea how i can overcome this problem in Qlik sense?
Great work around. Thanks for adding.
Do you know if there is a way to go back up. Using groups you can click on the dimension arrow which displays the previous level. Could this be done by using a button?, but not sure of the code.
You can use Qlikview back functionality.
Use image if you like.
Never thought of that
Thanks for your feedback