Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Marcos112
Partner - Contributor III
Partner - Contributor III

Rank () Ignore selection of date

Hello Everyone,

 

I think it's a simple query, I need to count the dates, I'm using the rank function that gives me the expected result, the problem is when I filter by a date, the rank returns to 1, so I need it to ignore the selection of that field(Fecha)

 

Thanks in advance

Marcos112_1-1680189589007.png

 

Labels (1)
2 Replies
Kushal_Chawda

@Marcos112  try below expression

=aggr(rank(- {<Fecha>}Fecha),Fecha)

Marcos112
Partner - Contributor III
Partner - Contributor III
Author

Thanks Kushal