Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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