dynamic text boxes

[srujanaponnuru]

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.

[rubenmarin]

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