topic Need help to prepare Rank list from expression in QlikView

Need help to prepare Rank list from expression

panwipa2528 — Mon, 10 Jun 2019 13:44:15 GMT

I need to create rank selection it make from expression as the table.

Re: Need help to prepare Rank list from expression

chrismarlow — Mon, 10 Jun 2019 19:03:59 GMT

Hi,

Check this post that I think answers your question;

https://community.qlik.com/t5/QlikView-Creating-Analytics/Selection-based-on-calculated-field/td-p/369073

So you should be able to pick up your formulae up from your Rank column & paste into aggr(YOUR FUNCTION, Member_ID), but you would need to unpick any column references you might have used to do the formula (I can't open your QVW as I only have personal edition, so don't know what your formula looks like, but I would have referenced the columns).

Cheers,

Chris.

Re: Need help to prepare Rank list from expression

sunny_talwar — Mon, 10 Jun 2019 19:18:41 GMT

Try with this expression to be exact which is inline with @chrismarlow mentioned

=Aggr( if(((sum({<Member_ID>}Sale)-sum({<Member_ID>}Target))/sum({<Member_ID>}Target)*100)>=120, '>120%', if((sum({<Member_ID>}Sale)-sum({<Member_ID>}Target))/sum({<Member_ID>}Target)*100>=100 and (sum({<Member_ID>}Sale)-sum({<Member_ID>}Target))/sum({<Member_ID>}Target)*100<120,'100-120%', if((sum({<Member_ID>}Sale)-sum({<Member_ID>}Target))/sum({<Member_ID>}Target)*100<0 ,'<0%', if((sum({<Member_ID>}Sale)-sum({<Member_ID>}Target))/sum({<Member_ID>}Target)*100>=0 and (sum({<Member_ID>}Sale)-sum({<Member_ID>}Target))/sum({<Member_ID>}Target)*100<100,'<100%')))), Member_ID)

Re: Need help to prepare Rank list from expression

panwipa2528 — Tue, 11 Jun 2019 02:35:41 GMT

Thank you Thank you Thank you for Sunny & Chris.