topic Re: Getting the name from =GetFieldSelections(<TableName>.ID) in QlikView

Getting the name from =GetFieldSelections(.ID)

Wed, 27 Aug 2014 12:12:41 GMT

Hi, I have a straight table and some text boxes outside of it, where I want the text boxes to display the name of the client when the name OR ID is selected. I know how to get it if its the name using: =GetFieldSelections(<TableName>.Name) , but I want this textbox to display the name if even the ID is selected (<TableName>.ID). Anyone have any ideas?

Thanks!

Re: Getting the name from =GetFieldSelections(.ID)

Gysbert_Wassenaar — Wed, 27 Aug 2014 12:16:30 GMT

Try =only(<TableName>.Name)

Re: Getting the name from =GetFieldSelections(.ID)

giakoum — Wed, 27 Aug 2014 12:16:34 GMT

if(getselectedcount(id) >0 or getselectedcount(name) >0 , GetFieldSelections(<TableName>.Name))

or similar

Re: Getting the name from =GetFieldSelections(.ID)

Wed, 27 Aug 2014 12:17:48 GMT

Hi David,

can maybe just use only for this.

=Only(Name)

Once you limit down to a single name or ID, the name will display for you

hope that helps

Joe

Re: Getting the name from =GetFieldSelections(.ID)

Wed, 27 Aug 2014 12:23:49 GMT

wow super easy many thanks!

Re: Getting the name from =GetFieldSelections(.ID)

jagan — Wed, 27 Aug 2014 12:32:55 GMT

Hi,

Also you can use

MaxString(Name) Or MinString(Name), if you select a value you will get the selected value otherwise it will give the max string name.

By using this you always get the answer, whether you selected or not.

Hope this helps you.

Regards,

Jagan.