topic Re: Rank variables in QlikView

Rank variables

Thu, 25 Dec 2014 21:02:52 GMT

hi to all

I have some variables that each return values

how can rank these values and show in a text box.

(rank var1 and var2 ,....)

Re: Rank variables

robert_mika — Thu, 25 Dec 2014 22:01:46 GMT

Could you provide sample of your data?

Re: Rank variables

Fri, 26 Dec 2014 06:50:42 GMT

Dear Robert

I attached sample and write something that I want in a text box in file

thanks

Re: Rank variables

amit_saini — Fri, 26 Dec 2014 07:10:39 GMT

Hi,

Check This:

http://community.qlik.com/message/580547#580547

http://community.qlik.com/message/611795#611795

Thanks,.
AS

Re: Rank variables

Fri, 26 Dec 2014 07:24:58 GMT

dear amit,

as you see in that posts there arenot any sample of rank variables

I think my problem is dont know how to connect each varible to one desired customer for example

varible1 to customer1 & varible 2 to customer2 .... in my sample attachment

If i do this rank of variables(customers) would be easy

thanks

Re: Rank variables

Gysbert_Wassenaar — Fri, 26 Dec 2014 07:58:52 GMT

See attached qvw.

Re: Rank variables

anbu1984 — Fri, 26 Dec 2014 08:03:23 GMT

= 'Rank of ' & Variable1 & ':' & If(Variable1 > Variable2,1,2) & Chr(10)

& 'Rank of ' & Variable2 & ':' & If(Variable2 > Variable1,1,2)

= 'Rank of ' & Variable1 & ':' & If(Variable1 > Variable2,If(Variable1 > Variable3,1,2),3) & Chr(10)

& 'Rank of ' & Variable2 & ':' & If(Variable2 > Variable1,If(Variable2 > Variable3,1,2),If(Variable2 > Variable3,2,3)) & Chr(10)

& 'Rank of ' & Variable3 & ':' & If(Variable3 > Variable1,If(Variable3 > Variable2,1,2),If(Variable3 > Variable2,2,3))

Re: Rank variables

Fri, 26 Dec 2014 08:14:30 GMT

dear anbu

there is 40 variable(slider that input from user) and write this for every would be tedious

the next problem is how to connect variables to field name customer

(varible1 to customer1 & varible 2 to customer2 .... ) in attached example

Re: Rank variables

Fri, 26 Dec 2014 08:26:25 GMT

Dear Gysbert

it would be correct but each variables belong to one of customers so when I write " rank(Variable1 ..."

it calculate for all customers not for example customer1

thanks

Re: Rank variables

Fri, 26 Dec 2014 21:21:52 GMT

Is there any solution to rank variables that got from sliders ?

Re: Rank variables

Gysbert_Wassenaar — Sat, 27 Dec 2014 09:34:48 GMT

See attached qvw