Rank function and Aggr

[Yuhka]

Hello qlikers, I'm new to qlikview.

I have a sample data which has four columns No, item1, item2 and item3.

I made a pivot table on my QVW to count No and get the rank of item1&2 in this table.

Regarding the Rank function and pivot table, I have a few questions and now I cannot get the result as I want.

1. When I record the QVW after sorting source data(No; ascending), the rank of pivot tale is changed.

Is the rank function affected by the sorting of source data as its specification?

2.  When I switch the dimension of the pivot table, the rank of pivot table is changed.

Is the order of dimension effecting to the result of rank function?

3. I'm using aggr and rank function to get the rank of item1&2 as follows.

=Aggr(Rank(Count(distinct No)),(item1),(item2))

In case to replace the setting order of  (item1) and (item2), the rank result on the pivot table is changed.

For aggr expression setting multiple dimensions, is the setting order chenges the result?

Thank you for your support. 

[Brett_Bleess]

Yuhka, long shot here I think, but I wanted to toss it out to see if it might possibly help, unfortunately I am not much of a developer, but my post will kick things back up too, so someone else may see things now too and leave other comments...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

[Frank_Hartmann]

try this as second dimension:

=Aggr(Rank(Count(distinct [2_No]),2),[2_item1],[2_item2])