Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bijay_jha
Creator
Creator

Position of Drill Down

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

No of Dimension.jpg

1 Solution

Accepted Solutions
bijay_jha
Creator
Creator
Author

Thanks Everyone,

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

4 Replies
bijay_jha
Creator
Creator
Author

chart.jpg

My main motive behind is that I wanted to hide the line chart when the

third dimension is selected.

prma7799
Master III
Master III

Please share some sample data.

passionate
Specialist
Specialist

Hi,

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,

if(GetSelectedCount(State)>0,4,

)))

And use this variable where ever required.

Regards,

Pankaj

bijay_jha
Creator
Creator
Author

Thanks Everyone,

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