topic Re: Need to get a User Defined Name from Text Object in List Box Title on Selection in QlikView

Need to get a User Defined Name from Text Object in List Box Title on Selection

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have created multiple text objects as a filter. I have assigned a variable which is associated with the attributes in the table. I need to show the user defined attribute name in the list box title on selection of the text object and not the actual attribute name from the table.

How to achieve this?

Abhijit

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

sunny_talwar — Mon, 03 Oct 2016 15:41:41 GMT

How is user expected to provide a name? Input box?

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Michael_Tarallo — Mon, 03 Oct 2016 15:52:02 GMT

Hello Abhijit - is this for QlikView?

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 15:53:22 GMT

I need to show the Text which is highlighted in yellow and not the actual attribute name from the table.

Suppose the actual attribute in the table is DistinctTable.LeadVehicle. But I need to show it as Lead Vehicle. Please see the attached screen shot of the text object properties.

Abhijit

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 15:53:49 GMT

Yes Michael,

This is for QlikView.

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 18:47:31 GMT

Any update on this?

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

sunny_talwar — Mon, 03 Oct 2016 19:03:00 GMT

To tell you the truth, I am still not sure what you are trying to do. May be if you can share a sample and explain what you want, we might be able to help you better

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 19:14:36 GMT

Hi Sunny,

Hereby I am sahring you the UI screen shot to tell you what exactly I need.

On left side I have text object. Text Object acts as a button in my case. I have assigned a variable to it. On click, the listbox title should show "LEAD VEHICLE" and not "DistinctTable.LEAD_VEHICLE". Hope this clears my question.

Abhijit

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

sunny_talwar — Mon, 03 Oct 2016 19:16:57 GMT

Within your button create another variable and call it vTitle and assign it the value of Lead Vehicle. And then within your listbox object use the vTitle as your chart title's expression.

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 19:26:19 GMT

Sunny,

I have multiple text objects and on click of that particular text object it show show the Title. How to achieve this?

I have text objects as a button on Left side. On click of that particular button it should show the title.

Abhijit

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

sunny_talwar — Mon, 03 Oct 2016 19:28:53 GMT

Abhijit -

You need to do the same thing for all your text box object. I am afraid, I might not be able to help any better without a sample. With a sample, I might be able to show you how this can be done. But your reluctance to share is making it very difficult for me to explain how this can be done.

See if this post can help you share a sample

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 19:43:04 GMT

Hi Sunny,

Thanks for sharing those links. That helped me in reducing the size. Hereby I am sharing a file with you. Please have a look.

Abhijit

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

sunny_talwar — Mon, 03 Oct 2016 19:46:59 GMT

I did it for three buttons so that you can understand the concept of what I was trying to do. See if this helps

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 19:50:12 GMT

Thank you Sunny!

This one is the perfect solution.

Abhijit

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

sunny_talwar — Mon, 03 Oct 2016 19:51:19 GMT

See how simple life becomes once you share a sample

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

Mon, 03 Oct 2016 19:58:16 GMT

That's very true. I wan't sure about this reduced data thing. In fact I started working on QV just few days back. So I am in learning mode.

Re: Need to get a User Defined Name from Text Object in List Box Title on Selection

sunny_talwar — Mon, 03 Oct 2016 19:59:43 GMT

We all learning my friend. I have been working QlikView for about 2 years now and I still learn new things everyday.