Dynamic Variables not changing in Section access for Qlik Sense using getfieldselections
Hi All,
I have implemented section access in Qliksense with geo level hierarchy . The structure of hierarchy is REGION->Territory->SalesGroup with amount as a measure. Now client want to view the sales in TKL as well as in KL as UOM.
For this we have created a variable vKLTKL = if( getselectedcount(SalesGroup) >= 1 or getselectedcount(Customer) >= 1,1,1000)
1 -> KL
1000 -> TKL.
When we reload the app with section access and if we assign a particular sales group to an user and when we open QVF TKL to KL Flip is not working properly for section access with getselectedcount () function where as same is working fine without section access.
Any idea why it is not working ?
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.
We need to change the value of variable as per level defined in section access suppose user want to view the measures in KL at salesgroup level then vKLTKL should change to 1 or for rest levels it should remains 1000
Is there any alternative function like getselectedcount and which will work with section access ?
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.
