Rank variables

[#1]

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 ,....)

[robert_mika]

Could you provide sample of your data?

[#3]

Dear Robert

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

thanks

[amit_saini]

Hi,

Check This:

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

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

Thanks,.
AS

[#5]

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

[Gysbert_Wassenaar]

See attached qvw.

[anbu1984]

= '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))

[#8]

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

[#9]

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

[#10]

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