how to create dynamic text box

[srujanaponnuru]

hi,

Please help me regarding this issue.

I have application name and User base columns. In qlikview, I created a search button with application name. so whehn I click on application name automatically I should get the value of user base in  atext box.

I have created a text box as user base and given the expresiion as

=If(Len(GetFieldSelections([Application Name])),[User Base],'Search for Application')

but this is not working

[jonathandienst]

I am not at all sure what you require, so i suggest that you post a small sample QVW file with some representative data, and clearly explain what you are trying to do and what result is expected.

[Digvijay_Singh · Accepted solution]

Try concat([User Base]) -

=If(Len(GetFieldSelections([Application Name])),concat([User Base]),'Search for Application')

[vinieme12]

is this what you are trying to do?

[srujanaponnuru]

I got it right

and similar way way I have a text box as total users, when I click on application name I need to get the total count of users in that box

[Digvijay_Singh]

Did you try count(distinct [User Base])

=If(Len(GetFieldSelections([Application Name])),count(distinct [User Base])),'Search for Application')

[srujanaponnuru]

yes, I tried the same way.

[Digvijay_Singh]

Can you share what output you are getting, ensure you are counting the correct field.

[srujanaponnuru]

attaching qvw file and excel

[Digvijay_Singh]

having personal edition so cannot access qvw but as per your data sample, I think you should use sum([# of users] instead of count.