topic Re: Text Box object Display Values in QlikView

Text Box object Display Values

Wed, 11 Mar 2015 12:18:45 GMT

Hi,

I have a listbox which contains a set of values. Now there is a field related to what I select in listbox.

I want to display content of that field in text box even when the field is not selected.

Eg. Suppose I have a filed 'A' and corresponding to that there is a record in field 'B'. Now when I select data in field 'A' i see all the data related to it.However I want to display the data of field B in a text box in other sheet when I select data in field 'A'.

Thanks In Advance

Regards,

Manu

Re: Text Box object Display Values

MK_QSL — Wed, 11 Mar 2015 12:25:49 GMT

Like this?

Re: Text Box object Display Values

Anonymous — Wed, 11 Mar 2015 12:26:35 GMT

use below

If you do Concat(FieldName,','), you should get all the possible values in a field comma separated.

Re: Text Box object Display Values

datanibbler — Wed, 11 Mar 2015 12:31:58 GMT

Hi,

if I understand you correctly, you want to make field_B work in two different ways - one is linked to selections in field_A and one would be independent of field_A?

You would need to work with "alternate states" to achieve that, Unfortunately I haven't got any experience with that as I never had any need for that function yet.

Re: Text Box object Display Values

Wed, 11 Mar 2015 12:33:33 GMT

Hi Nishant,

Thanks for the prompt reply.

Actually this gives me all field values even when I have selected nothing. I want data in text box only when i select something in other field.

Regards,

Manu

Re: Text Box object Display Values

Wed, 11 Mar 2015 12:36:23 GMT

Hi Datanibbler,

Exactly what you understood. I want to display data from field B based on the selections in Field A.

But unfortunately I am not getting it.

Regards,

Manu

Re: Text Box object Display Values

Wed, 11 Mar 2015 12:38:22 GMT

Hi Manish,

thanks for prompt reply.

Actually I cant access the qvw file as the installation is on server and there is no way to transfer files from my system to that server.

Regards,

Manu

Re: Text Box object Display Values

Anonymous — Wed, 11 Mar 2015 12:39:18 GMT

can u try like something. I am not at my qlikview machine so cnt try n tell u exact code

Concat(getselected(FieldName),',')

Re: Text Box object Display Values

Wed, 11 Mar 2015 12:53:14 GMT

I tried but I think function getselected is not there. there is one function GETCURRENTFIELD.Can I use this in someway to get the desired result?

Re: Text Box object Display Values

Gabriel — Wed, 11 Mar 2015 12:58:56 GMT

Hi,

In 1 text box use this expression

=CONCAT(Field_A,CHR(10))

In another text box use this

=CONCAT(IF(GetSelectedCount(Field_B), Field_A),CHR(10))

Hope that helps

Re: Text Box object Display Values

Thu, 12 Mar 2015 07:31:30 GMT

Thanks a Lot Gabriel ..

Re: Text Box object Display Values

MK_QSL — Thu, 12 Mar 2015 08:32:25 GMT

Pity that I have given exactly the same solution but you don't have access of QV apps... But Happy that you have not solution for the same...

Happy Qliking !

Re: Text Box object Display Values

Thu, 12 Mar 2015 08:37:00 GMT

Have I been able to access the qvw file provided by you I would have saved some of my time.

Thanks a lot..

Re: Text Box object Display Values

MK_QSL — Thu, 12 Mar 2015 08:40:02 GMT

When you replied on my answer, I was busy in my project otherwise I would have replied back immediately... Anyhow, your problem solved which is what more important... But I would prefer someone while asking question, should mention that I don't have access to QVW apps or have personal edition, so please reply by text only.... this would obviously help..

Re: Text Box object Display Values

nikhilgarg — Thu, 12 Mar 2015 09:43:14 GMT

Hey,

But he needs only to show value of Field B in only one textbox in other sheet. Then why you have suggested 2 expressions for 2 textbox. Plz explain.

thanks

Re: Text Box object Display Values

nikhilgarg — Thu, 12 Mar 2015 09:45:19 GMT

Hey,

But you needs only to show value of Field B in only one textbox in other sheet. Then why you have used 2 expressions for 2 textbox. Plz explain.

thanks