topic Rank Function in QlikView

Rank Function

Sat, 05 Dec 2009 00:29:58 GMT

I have a *.qvw attached where I'm trying to rank on multiple dimensions. All I'm trying to do is literally take the Baseline chart and add another column that shows the rank (1-10). I thought this could be done by using the rank function (attempted in the "Rank Example" chart) but it's the "# Valid Consumer Submissions" by id and region instead of just ranking by the "#Valid Consumer Submissions" column. I understand why it's doing that, but I don't know how to adjust my chart so my rank is based on "# Valid Consumer Submissions".

Anyone have any thoughts?

thanks,

rob

Rank Function

Sat, 05 Dec 2009 00:50:02 GMT

We were able to figure it out. We needed to have the "TOTAL" before the "sum".

rank(TOTAL sum(if(is_staff=0,IsValidSubmission,0)))

rob

Rank Function

johnw — Sat, 05 Dec 2009 01:00:22 GMT

If I understand the question, just use "total":

rank(total sum(if(is_staff=0,IsValidSubmission,0)))

Rank Function

johnw — Sat, 05 Dec 2009 01:00:52 GMT

Doh! I swear your post wasn't there when I wrote this.