topic Picking values based on Rank in QlikView

Picking values based on Rank

Mon, 04 Mar 2013 18:00:15 GMT

Hi all,

I have a set of data and I would like to be able to compare the current value with the previous value. I may need to compare back a few versions down the line also.

Please see the attached PDF for the way the data is structured.

I am thinking that I should combine the Update ID and Audit Update ID values and then use the Rank function to order them. The top ranking item will be the current value and the next ranking item with be the previous item. I would like to display this within a straight table.

The ranking should be grouped by Action Item ID.

I have no experience using the Rank function and would appreciate any help that the community can provide in terms of how best to approach this.

Many thanks,

Alan

Re: Picking values based on Rank

Anonymous — Mon, 04 Mar 2013 18:39:24 GMT

Hi,

please fiend the attachment of application and let me know it is us efull or not.

Regards

SHAIK

Re: Picking values based on Rank

Mon, 04 Mar 2013 18:53:03 GMT

Hi Shaik,

Thanks for your quick response.

Rather than ranking based on percentage complete, I would like the results to be ranked based on Update ID + Audit Update ID.

Your expression should do the trick. Would you mind explaining how it works esp the Aggr & Rank elements.

=Aggr(num(rank([% complete],4)),[Audit Update ID])

Thanks,

Alan

Re: Picking values based on Rank

Anonymous — Mon, 04 Mar 2013 18:58:13 GMT

Hi,

aggr function like group function only,how we are applying group function is scripting ,same like in chart,

how it will be working is,it will be create table based on [Audit Update ID] and after rank function will be create rank for them based on [% complete] value.if any query let me know.

Regards

SHAIK

Re: Picking values based on Rank

Thu, 07 Mar 2013 17:50:14 GMT

Hi Shaik,

I have been able to return the correct Audit Update ID using the below expression:

aggr(num(max([Audit Update ID],2)),[Update ID],[Action Item ID])

How do I return the % Complete?

Thanks,

Alan

Re: Picking values based on Rank

Fri, 08 Mar 2013 09:51:34 GMT

Anyone any ideas??

Thanks,

Alan