Showing data in charts according to role wise access to dashboard

[poojakaikade]

Hi All,

I have two charts based on different level like 1) BG level chart 2) ISU level chart

when I'm login using corpuser data is fine

but if I'm login in UAT using ISU head ID which is tagged to single ISU then in ISU level chart, bar & value is coming for single ISU but in BG level chart it is showing sum of all the ISUs tagged to that BG.

But I want only the sum of ISUs tagged to that ID in BG level chart 

Pick(match(vView,'Contract Active','Contract Active in 90 Days','All'),
sum(distinct{<LEVELID_KPI5={5},CSA_Active_Levelid5={1}>}ACTIVE_COUNT5),
sum(distinct{<LEVELID_KPI5={5},CSA_Last_90Days_levelid5={1}>}ACTIVE_COUNT5),
sum(distinct{<LEVELID_KPI5={5},CSA_Active_Levelid5={1}>+<LEVELID_KPI5={5},CSA_Last_90Days_levelid5={1}>}ACTIVE_COUNT5)
)
 This is the expression I'm using for calculating BG level chart.  LEVELID_KPI5={5} this means BG level

for ISU level its LEVELID_KPI5={4}

Kindly help to resolve this issue

Thanks in Advance
Pooja

[ajaykakkar93]

Hi,

you can consider using session access in qlik will will restrict data kpi values & provide the same for that user.

Example:
User 1 with LEVELID_KPI5 = 5
User 2 with LEVELID_KPI5 = 4
User 3 with LEVELID_KPI5 = 4
User 4 with LEVELID_KPI5 = 2
User 5 with LEVELID_KPI5 = 1

Create a variable with the below expression 
Variable Name: vLEVELID_KPI5_Value
Variable Def: =concat(LEVELID_KPI5,',')


Add the variable in the expression 

Pick(match(vView,'Contract Active','Contract Active in 90 Days','All'),
sum(distinct{<LEVELID_KPI5={$(vLEVELID_KPI5_Value)},CSA_Active_Levelid5={1}>}ACTIVE_COUNT5),
sum(distinct{<LEVELID_KPI5={$(vLEVELID_KPI5_Value)},CSA_Last_90Days_levelid5={1}>}ACTIVE_COUNT5),
sum(distinct{<LEVELID_KPI5={$(vLEVELID_KPI5_Value)},CSA_Active_Levelid5={1}>+<LEVELID_KPI5={$(vLEVELID_KPI5_Value)},CSA_Last_90Days_levelid5={1}>}ACTIVE_COUNT5)


Hope it helps