Discussion Board for collaboration related to QlikView App Development.
Good Morning Every One.
Today I am trying to get the position number of Drill Down.
For Example: In Dynamic Drill Down you can see you have 3 dimensions.
So my Question is,
When I Drill down the data twice i will be in third Dimension so i must get the result 3
=PositionNumber(Dynamic Drill Down) = 3 when I drill down the data twice
I found the Answer: GetCurrentField----------It will give you the field name from the group which ever is selected.
=if(GetCurrentField([Dynamic Drill down])= 'E_CREATED_BY_USER',1,0)
View solution in original post
My main motive behind is that I wanted to hide the line chart when the
third dimension is selected.
Please share some sample data.
I have drill down of continent,Country,State and Branch:
You can add a variable and set its value to below:
=if(GetSelectedCount(Continent)>0 and GetSelectedCount(Country)=0 and GetSelectedCount(State)=0,2,
if(GetSelectedCount(Country)>0 and GetSelectedCount(State)=0,3,
And use this variable where ever required.