The first should rank the field [P/L] by DVPG, and STCK, from the highest to the lowest number. Something like this:
=Date(DVPG, 'DD/MM/YY')
STCK
=[P/L]
=RankPL
03/06/20
AALR3
133,67813848367
1
03/06/20
ALPA4
64,142973331921
2
03/06/20
AGRO3
30,789542066738
3
03/06/20
ABEV3
20,420386147316
4
03/06/20
BBDC4
9,5068188443067
5
03/06/20
BBDC3
8,7670571185802
6
03/06/20
BEES3
8,0984205714725
7
03/06/20
BBAS3
5,7988908772231
8
02/06/20
AALR3
124,68524553113
1
02/06/20
ALPA4
62,313030626898
2
02/06/20
AGRO3
30,712761698131
3
02/06/20
ABEV3
19,98886100609
4
The second should rank the field [ROE] by DVPG, and STCK, from the lowest to the highest number. Something like this:
=Date(DVPG, 'DD/MM/YY')
STCK
ROE
=RankROE
03/06/20
BBAS3
5,798890877
1
03/06/20
BEES3
8,098420571
2
03/06/20
BBDC3
8,767057119
3
03/06/20
BBDC4
9,506818844
4
03/06/20
ABEV3
20,42038615
5
03/06/20
AGRO3
30,78954207
6
03/06/20
ALPA4
64,14297333
7
03/06/20
AALR3
133,6781385
8
02/06/20
BBAS3
5,476822981
1
02/06/20
BEES3
7,63720399
2
And at the end of the day, I would like to create a table like this: As you can see here, for each date and STCK I'll have its rank for PL and ROE.
DVPG
STCK
RANK_PL
RANK_ROE
03/06/2020
AALR3
1
8
03/06/2020
ALPA4
2
7
03/06/2020
AGRO3
3
6
03/06/2020
ABEV3
4
5
How can I do that?
Please, take a look at my sample data. I was trying to use the AutoNumber([P/L], DVPG) as RankPL and it's working well, but just for the very first table. It's not resetting the counter for the second one.
I'm using QlikView Personal Edition, so please help me with the codes... I can't open any file back.
