topic Rank function and Aggr in QlikView

Rank function and Aggr

Yuhka — Sat, 16 Nov 2024 02:54:21 GMT

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.

Re: Rank function and Aggr

Brett_Bleess — Tue, 20 Aug 2019 12:49:16 GMT

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/RankingFunctions/HRank.htm

Regards,
Brett

Re: Rank function and Aggr

Frank_Hartmann — Tue, 20 Aug 2019 13:05:48 GMT

try this as second dimension:

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