Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank variables

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

10 Replies
robert_mika
Master III
Master III

Could you provide sample of your data?

Not applicable
Author

Dear Robert

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

thanks

Not applicable
Author

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.


talk is cheap, supply exceeds demand
anbu1984
Master III
Master III

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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