Based on User entry

[soniasweety]

Hi All,

@sunny_talwar    @Vegar 

i want to show the top N employess based on user entry/selections.  in both bar chart and strightable.

user want to see in 3 ways. mentioned in attached qvw.

Attached is the sample. can anyone help on this?

[sunny_talwar · Accepted solution]

Check attached

[soniasweety]

Hi @sunny_talwar ,

thanks its looking as i expected. but  could you please explain how it works  below exp?

EmployeeName = {"=Rank(Sum([Year Salary])) < ($(vRank) + 1)"}

and one more way need like..  can i give  list box with 5,10,15,20 ... like that user can select from list box? is it possible?

[sunny_talwar]

vRank is a variable set via the input box.... so I am comparing Rank to <  vRank + 1..

Can you post an updated sample with the list box which includes 5, 10, 15... make sure this isn't connected to any table in your app... should be an island table