Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ranking dates in qlikview

Hi all,

I'm trying to do some ranking for my work. The rank function should be on the date field per account number,

which means that 10.1 should rank with 1, 12.2 with 2 and etc..

I've searched and read that the rank function goes with the aggr function, but that's not my case here

problem.JPG

thanks a lot for any help

Omer

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try using

Aggr(rank(Date),account number, Date)

View solution in original post

8 Replies
el_aprendiz111
Specialist
Specialist

Hi,

Examp..

1)  Aggr(Rank(Aggr(Sum(totalamount), accountnumber), 1, 1),accountnumber) 

2)  avg(aggr(rank( sum( {$<accountnumber=>} totalamount) ), accountnumber))

3)  rank( sum( {$<accountnumber=>} totalamount) )

4)RowNo()

sunny_talwar

What is your Rank Expression here? Have you tried just this Rank(date)

Anonymous
Not applicable
Author

Hi,

Thanks for the examples, 

Is there any expression in your examples that I can change that will contain both the date and the account number?

Anonymous
Not applicable
Author

Hi,

the expression is - rank(date,account number)

but it's not working:)

if I'd do rank(date) , I'll get a rank all over the dates and not per account number

sunny_talwar

Have you tried Rank(date)? At least give it a shot and see if it gives you what you want.

Anonymous
Not applicable
Author

Try using

Aggr(rank(Date),account number, Date)

Anonymous
Not applicable
Author

Thanks!! this expression work combined with the sort tab

oknotsen
Master III
Master III

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!