Qlik Sense rank issue

Caroligian — Thu, 20 Jun 2019 08:02:16 GMT

Hi all,

I need to make the transition from an excel file, and in this excel file the rank funtion used is this: =RANK(X3,O3:X3,0)

I have to make a straight table which besides the data I have a rank column. The problem is that it should be made up of several sets of analysys.

I have ten fiscal quarters in the form of this formula :

=sum({<NrRand={$(vMaxFQ1)}>}[Ref Sellout Deal Net CLC])/sum(TOTAL<[Reporter HQ Organization],[Current Product Segment],[Month]>{<NrRand={$(vMaxFQ1)},[PEA Partner flag]=, [Reporter Partnername]=>}[Ref Sellout Deal Net CLC])

I tried a lot of things but they did not work.

How i can made this in qlik?

Thanks in advance.

topic Qlik Sense rank issue in App Development

Qlik Sense rank issue