Hi all,
I have used following user structure to implement the section access into qlik sense here I am using role base
hierarchy based on user role. for eg
| User Name | Access | User Id | REGION_NAME | State_Office |
|---|
| Johnr | USER | Domainid/Johnr | NR | UTTAR PRADESH |
| | | | |
which is working perfectly fine for me. Now issue is that i am using following formula to Identify when user is drilling down the hierarchy on which user has based on getselectedcount() function.
=IF(getselectedCOUNT(REGION_NAME)<1,'REGION_NAME',
IF(getselectedCOUNT(REGION_NAME)>=1 AND getselectedCOUNT([State_Office])<1,'State_Office',
IF(getselectedCOUNT(REGION_NAME)>=1 AND getselectedCOUNT([State_Office])>=1 and GetSelectedCount(Territory)<1,'Territory',
IF(getselectedCOUNT(REGION_NAME)>=1 AND getselectedCOUNT([State_Office])>=1 and GetSelectedCount(Territory)>=1 and GetSelectedCount(DistName)< 1 ,'DistName',
'DistName'))))
Issue:
1. If user has given state office level is there any way or method to identify that which level of Parent - child hierarchy I am currently
in other than getselectedcount() function ?.
2. When I pass user with State_Office level , then getselectedcount() won't change can we pass dynamic variables with section access so that we can get the current level of user on which he has ?
Regards
Vikas
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
