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