Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mgavidia
Creator
Creator

Problem with Rank function and Security Access

Hello there!, I hope someone can give some tips on how to resolved this problem.

I am using the Rank function to get a daily status on several operational tracking elements. (one sample below).

This works well when the chart displays all the ranked items.

PROBLEM:

I need to add this new chart to a dashboard where security access alllows users visibility to data that belongs to their facility only.

With this type of security the rankings levels are lost and the chart displays the single facility as number 1.

( Facility 48 ranks as 4th but, with the security enabled shows a single rank of 1.)

Is there a way to display the correct ranking as compared to others while hiding the ranking for other locations?

Is there a better way to accomplish that?

Thanks,

M. Gavidia

Los Angeles, CA.

Image-1963.png

2 Replies
prieper
Master II
Master II

Hi,

if related to section access you cannot calculate RANK dynamically, but have to do it in the script as the other dimensions are not visible for the indidual user (subj his rights).

Peter

mgavidia
Creator
Creator
Author

Peter,

Well, I was afraid that will be answer; I'll work it out in the script.

Thank you.