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.