topic Re: ranking dates in qlikview in QlikView

ranking dates in qlikview

Anonymous — Wed, 28 Jun 2017 08:23:06 GMT

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

thanks a lot for any help

Omer

Re: ranking dates in qlikview

el_aprendiz111 — Wed, 28 Jun 2017 17:25:48 GMT

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()

Re: ranking dates in qlikview

sunny_talwar — Wed, 28 Jun 2017 17:30:14 GMT

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

Re: ranking dates in qlikview

Anonymous — Thu, 29 Jun 2017 06:54:03 GMT

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?

Re: ranking dates in qlikview

Anonymous — Thu, 29 Jun 2017 07:00:54 GMT

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

Re: ranking dates in qlikview

sunny_talwar — Thu, 29 Jun 2017 16:30:48 GMT

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

Re: ranking dates in qlikview

Anonymous — Thu, 29 Jun 2017 21:10:51 GMT

Try using

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

Re: ranking dates in qlikview

Anonymous — Sun, 02 Jul 2017 15:12:43 GMT

Thanks!! this expression work combined with the sort tab

Re: ranking dates in qlikview

oknotsen — Sun, 02 Jul 2017 19:16:42 GMT

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 .