topic Re: Text box in QlikView

Text box

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

Hi All,

Plz help me to get clear of this,

Thanks in Advance.

I have fields like

cat1.code,cat1,cat2.code,cat2,cat3.code,cat3,cat4.code,cat4

10337,Ice cream,9324,Gallons,11385,Premium IC Gallaons,253,Choclate gallon

9319,Seafood,11374,Fish,9320,Fish Breaded,547,Parfried Breaded Haddock Sticks

so on

Here my requirement is if i select the code of any it has to show the related cat name in text box and viseversa.

Re: Text box

awhitfield — Wed, 31 May 2017 11:25:20 GMT

Hi Datha,

do you have a simple example QVW that you can upload to the Community?:

Best regards,

Andy

Re: Text box

Anonymous — Wed, 31 May 2017 11:28:23 GMT

Your requirement is not clear. Give one example with input and output. Or else upload sample data

Re: Text box

prieper — Wed, 31 May 2017 12:26:38 GMT

put into the textbox a formula like

= ONLY(cat1)

resp.

= ONLY([cat1.code])

This will show the corresponding values, if just one value is available.

Peter

Re: Text box

ramasaisaksoft — Wed, 31 May 2017 12:37:38 GMT

Please let us know which is ur filter ?

and what value you will select in that filter ?

and what value you want to see in text box ?as a output.

if you share your query clearly then we will help you on output.

Re: Text box

Anonymous — Wed, 31 May 2017 12:41:00 GMT

You can create two text boxes with Category code and Category Name. When you select any Category code in list box then corresponding values will get in Text boxes accordingly.

=Only(Category Code) or =(Category Code)

=Only(Category Name) or =(Category Name)

Hope it helps!!

Re: Text box

dathathreya — Wed, 31 May 2017 14:54:52 GMT

Hi ,

As per my requirement i am adding the list boxes for category name and for category codes.i want to show the selection in the text box as if i select the category name in the list box it has to display the category code in text box,if i select the category code in the list box it has to show the category name in the text box.

Re: Text box

prieper — Wed, 31 May 2017 15:01:55 GMT

please post an example along with the required behaviour

Re: Text box

awhitfield — Thu, 01 Jun 2017 11:30:18 GMT

Hi Datha,

please check the simple example as a starting point, to see if this is what you want.

Andy