topic Re: Problem with Rank function and Security Access in QlikView

Problem with Rank function and Security Access

mgavidia — Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Problem with Rank function and Security Access

prieper — Sat, 21 Mar 2015 08:50:56 GMT

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

Re: Problem with Rank function and Security Access

mgavidia — Mon, 23 Mar 2015 19:46:55 GMT

Peter,

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

Thank you.