dynamic text boxes

srujanaponnuru — Wed, 25 Nov 2020 16:16:04 GMT

hi,

Please help me regarding this issue.

I have application name and # of users columns. In qlikview, I created a search button with application name. so whehn I click on application name automatically I should get the total number of users in that text box.

I have created a text box as total users and given the expresiion as

=If(Len(GetFieldSelections(Application)), Count([# of Users]),'Search for Application')

b ut this is not working

attached is the excel file and qvw file.

Re: dynamic text boxes

rubenmarin — Mon, 19 Sep 2016 15:19:52 GMT

Hi srujana, Count() returns the number of occurrences, in the sample there is 1 value for [# of Users], with a stored value of '65' for application 'AME'.

You can try with Sum():

=If(Len(GetFieldSelections(Application)), Sum([# of Users]),'Search for Application')

topic Re: dynamic text boxes in QlikView

dynamic text boxes

Re: dynamic text boxes