Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ,....)
Could you provide sample of your data?
Dear Robert
I attached sample and write something that I want in a text box in file
thanks
Hi,
Check This:
http://community.qlik.com/message/580547#580547
http://community.qlik.com/message/611795#611795
Thanks,.
AS
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
See attached qvw.
= '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))
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
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
Is there any solution to rank variables that got from sliders ?