topic Re: Based on User entry in QlikView

Based on User entry

soniasweety — Sat, 16 Nov 2024 20:35:07 GMT

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?

Re: Based on User entry

sunny_talwar — Tue, 25 Jun 2019 18:18:29 GMT

Check attached

Re: Based on User entry

soniasweety — Wed, 26 Jun 2019 04:52:32 GMT

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?

Re: Based on User entry

sunny_talwar — Wed, 26 Jun 2019 11:11:15 GMT

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