topic Re: how to create dynamic text box in QlikView

how to create dynamic text box

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

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

Re: how to create dynamic text box

jonathandienst — Mon, 19 Sep 2016 13:34:34 GMT

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.

Re: how to create dynamic text box

Digvijay_Singh — Mon, 19 Sep 2016 13:35:31 GMT

Try concat([User Base]) -

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

Re: how to create dynamic text box

vinieme12 — Mon, 19 Sep 2016 13:36:19 GMT

is this what you are trying to do?

Re: how to create dynamic text box

srujanaponnuru — Mon, 19 Sep 2016 13:56:53 GMT

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

Re: how to create dynamic text box

Digvijay_Singh — Mon, 19 Sep 2016 14:00:33 GMT

Did you try count(distinct [User Base])

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

Re: how to create dynamic text box

srujanaponnuru — Mon, 19 Sep 2016 14:02:55 GMT

yes, I tried the same way.

Re: how to create dynamic text box

Digvijay_Singh — Mon, 19 Sep 2016 14:06:57 GMT

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

Re: how to create dynamic text box

srujanaponnuru — Mon, 19 Sep 2016 14:18:30 GMT

attaching qvw file and excel

Re: how to create dynamic text box

Digvijay_Singh — Mon, 19 Sep 2016 14:59:38 GMT

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