Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qvraj123
Contributor II

diff between dimension limits and rank - largest 10 and rank - see the difference numbers

hi , thanks for your time

I have the below scenario where i am trying to get the top - to test if the expression is working fine i tried to use the dimension limits with largest 10 and i see the difference in rank and the dim limits -

Capture123.PNG

I have the following dimension and the expressions in 2 diff straight tables

st table with dim limits for largest 10

Dimension -

=IF(not ISNULL([Analyst Name]),[Analyst Name],'Exclude Null')

Expression

AGGR(
Sum(if(not isnull( [Analyst Name] ) and Action='Opened Report' and REDUCTION='EQUITY',ReadCounter,0)),[Analyst Name]
)

st table with RANK function

dimension -

=IF(not ISNULL([Analyst Name]),[Analyst Name],'Exclude Null')

Expression -

=IF(AGGR(Rank(Sum({< [Analyst Name] -= {"=isnull([Analyst Name])" }, REDUCTION = {"EQUITY"}, Action={'Opened Report'} >} ReadCounter),4), [Analyst Name]) <=10,

Sum({< [Analyst Name] -= {"=isnull([Analyst Name])" }, REDUCTION = {"EQUITY"}, Action={"Opened Report"} >} ReadCounter),

0
)

if i look at the both numbers i thought i would get the same numbers but there is a difference

what could be the reasons - just suggestions on what to look for - really appreciate your time

1 Reply
Support
Support

Re: diff between dimension limits and rank - largest 10 and rank - see the difference numbers

In this case it will likely help if you attach a small sample app with the data model and some data etc., so folks can actually dig into everything more easily to try to help you.

The only other thing I can suggest is checking the Design Blog area on the Community to see if any of the posts there may help get you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.